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.

N6223BSpirek Aaron M · Henderson, NVBuilt 1978 · S/N 21062712 N6224AAviation Of North Florida LLC · Jacksonville, FLS/N 33024 N6224FMerrill James · Bigfork, MTBuilt 1975 · S/N 18264130 N6225AMilpower Inc · Nampa, IDBuilt 1956 · S/N 33025 N6225QElkinton Dusty Lee · Moundville, MOBuilt 1955 · S/N 31957 N6226ADaggett Aviation Inc · Daggett, CABuilt 1956 · S/N 33026 N6226FLone Creek Ranch LLC · Williston, NDBuilt 1975 · S/N 18264131 N6227AAllur Air LLC · Minnetrista, MNBuilt 1956 · S/N 33027 N6227FAlund Timothy · Watervliet, NYBuilt 1975 · S/N 18264132 N6227YWest Brook Group Inc · Pleasant Hill, IABuilt 1981 · S/N 21064301 N6229ABrown Jennifer L · Vancouver, WAS/N 33029 N6229CClause James W Trustee · La Quinta, CABuilt 1979 · S/N 21063838 N6229EBidus Brent E · Sandpoint, IDBuilt 1983 · S/N 18268353 N6229FGav Air Capital LLC · Trophy Club, TXBuilt 1975 · S/N 18264133 N622FEPeninsula Aero Technology Inc · Kenai, AKBuilt 1971 · S/N 18260805 N622FHNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282184 N622KCAir Burt LLC · Rochester Hills, MIBuilt 2001 · S/N 18281043 N6232APeters Duane A · Anchorage, AKBuilt 1956 · S/N 33032 N6233AAgl Aero LLC · Mckinney, TXS/N 33033 N6233FBach Haley Rayna · Sedona, AZS/N 18264135 N6233ZMission Aviation Fellowship · Nampa, IDBuilt 1981 · S/N U20606195 N6234ALiu Weston B · Brookline, NHBuilt 1956 · S/N 33034 N6235AStewart Madison F Co Personal Representative · Broken Arrow, OKS/N 33035 N6236MJlkd LLC · Lewes, DEBuilt 2008 · S/N 18282075 N6237FPerea Joseph R · Albuquerque, NMBuilt 1975 · S/N 18264139 N6237YStrategic Sourcing Solutions Inc · Topeka, KSBuilt 1981 · S/N 21064303 N6238UInland Crop Dusters Inc · Shafter, CABuilt 1979 · S/N U20605393 N6239APara Plane Aviation Inc · Thomasboro, ILS/N 33039 N6239YBlue Horizon Aviation LLC · New Concord, OHBuilt 1981 · S/N 21064304 N623DWHtft LLC · Las Vegas, NVS/N 18281094 N623EPApex Aviation LLC · Exeter, NHBuilt 1975 · S/N 18052616 N623RTTextron Aviation Inc · Wichita, KSS/N 18283363 N623UTTextron Aviation Inc · Wichita, KSS/N 18283362 N623WTChasteen Tom · Tavernier, FLBuilt 1963 · S/N 205-0328 N62400Henline Matthew · Honolulu, HIBuilt 1972 · S/N 18261290 N6240BVan Treese Farms Inc · Monte Vista, COBuilt 1978 · S/N 21062718 N6241AAerial Messages Leasing Co · Longwood, FLBuilt 1956 · S/N 33041 N6241FBucks Mont Masonry Inc · Green Lane, PABuilt 1975 · S/N 18264141 N6241NSt Croix Recreation LLC · Mulberry, FLS/N 18267807 N6243AKolar James P · Mendota Heights, MNBuilt 1956 · S/N 33043 N6243CDcd Aircraft Sales LLC · Leesburg, FLS/N 21063841 N6243ZSeattle Seaplanes LLC · Seattle, WABuilt 1981 · S/N U20606199 N6244ASioholm William N Jr · Wallingford, CTFirst renewal noticeBuilt 1956 · S/N 33044 N6245ABackcountry Guys LLC · Prescott, AZBuilt 1956 · S/N 33045 N6245NRoy Robert William · Cumming, GABuilt 2008 · S/N 18282086 N6245SFillmore Aviation LLC · South Saint Paul, MNBuilt 1980 · S/N R18201653 N6245XWarrington Flying Club Inc · Doylestown, PABuilt 2008 · S/N 18282089 N6246AWirt James L · Goldsby, OKS/N 33046 N6246BR L Equipment And Services LLC · Monument, COBuilt 1978 · S/N 21062721 N624CFCorona Jose Jr · Corona, CAS/N 18281059

Back to AD 84-10-01 R1