Skip to content

Registered aircraft · 20,481

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N5446BDavis Elizabeth · Flagstaff, AZBuilt 1956 · S/N 33446 N5448BDesjardins Norman W · Gresham, ORBuilt 1956 · S/N 33448 N5448NRadial Enterprises LLC · New Carlisle, OHBuilt 1980 · S/N 18267722 N544ZLeary Ken R · Fairbanks, AKBuilt 1971 · S/N 18052190 N545Providence Aerospace LLC · Choctaw, OKS/N 50001 N5450BKunz George M · Bakersfield, CABuilt 1956 · S/N 33450 N5451NMiller Geoffrey J · Tucson, AZBuilt 1980 · S/N 18267724 N5451VParker James C · Cuthbert, GABuilt 1975 · S/N 21060952 N5453BGoggans John L · Mansfield, MOS/N 33453 N5454NLeisure Flight LLC · Franklin, TNBuilt 1980 · S/N 18267725 N5455NPage Michael C Trustee · Stuart, FLBuilt 1980 · S/N 18267726 N5456EKais Air LLC · Terre Haute, INBuilt 1983 · S/N 18268323 N5456NBazar Paula · Woodland Hills, CABuilt 1980 · S/N 18267727 N5456YWings As Eagles LLC · Wilmington, DES/N 21064211 N54572Perry Dennis T · Seward, AKS/N 18052256 N5457BBg Family Lp · Edinburg, TXBuilt 1956 · S/N 33457 N5459BBonnell Aaron K · Orland Park, ILBuilt 1956 · S/N 33459 N545BLJaeger Stacey K · Towner, NDBuilt 1969 · S/N 18260124 N545DHaskell Corporation · Bellingham, WABuilt 1985 · S/N U20606892 N545DTSkahill Earl DBA · Denver, COS/N 18259236 N545FAJb Aircraft LLC · Anchorage, AKBuilt 1980 · S/N 20700592 N545MCBarnes Robert Edward Jr · Mason, OHBuilt 1999 · S/N 18280530 N545ML3rd Coast Air LLC · Traverse City, MIS/N 21062821 N545PSUnited States Department Of The Interior · Boise, IDBuilt 1983 · S/N U20606702 N545WKenmore Crew Leasing Inc Trustee · Bellingham, WAS/N 21060656 N5461XState Of Alaska · Anchorage, AKBuilt 1980 · S/N U20605775 N54626Continental Title Trust LLC Trustee · Wichita, KSBuilt 1970 · S/N 18260199 N5462THebert David · Lafayette, LABuilt 1982 · S/N R18201874 N5463NM Sipolt Air LLC · Paradise Valley, AZBuilt 1980 · S/N 18267734 N5464VLivingood Richard A · Tucson, AZS/N 21060955 N5465BFischer Alfred M DBA · Genoa City, WIS/N 33465 N5465SSherwood Steven · Saint Louis, MOBuilt 1980 · S/N R18201579 N5466EPeterson Paul E · Port Charlotte, FLS/N 18051363 N5467APiedmont Air Services LLC · Helena, MTBuilt 1979 · S/N 21063454 N5467BSwank Michael G · Shreve, OHBuilt 1956 · S/N 33467 N5467CSteamboat Springs Flying Club Inc · Steamboat Springs, COBuilt 1998 · S/N 18280230 N5468BCullinane Patrick J · Pasco, WAS/N 33468 N5469BDo Enterprises LLC · Port Charlotte, FLS/N 33469 N546KWard Mark E · Brookfield, WIBuilt 2001 · S/N 18281013 N5471BLowenstein Jeffrey · Juneau, AKBuilt 1956 · S/N 33471 N5471NRiley Aviation LLC · Columbia, TNBuilt 1980 · S/N 18267741 N5473BWalsh David P Jr · Macon, GABuilt 1956 · S/N 33473 N5473NVan Wagenen Robert F · Watsonville, CABuilt 1980 · S/N 18267743 N5473TTiernan Barton M · Anchorage, AKBuilt 1982 · S/N R18201876 N5476YAltura Aviation 2 LLC · Charlotte, NCBuilt 1980 · S/N 21064219 N5477Hudson Lake Properties LLC · Pryor, OKBuilt 1956 · S/N 33477 N5478JBuck Loenard J · Curtice, OHS/N 18052774 N5478NSkylane Aviation Club LLC · New Orleans, LABuilt 1980 · S/N 18267747 N5479NTahoe Flying Club Inc · Truckee, CABuilt 1980 · S/N 18267748 N547CSForever Dream LLC · Wilmington, DEBuilt 2019 · S/N 18283084

Back to AD 84-10-01 R1