Registered aircraft · 108,428

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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.

N1400HAmeriflyers Of Texas Inc · Addison, TXBuilt 2006 · S/N 172S10410 N1400PJohnson Melanie Trustee · Saint James, MNFirst renewal noticeBuilt 1983 · S/N 3 N1401EUnited States Air Force Aero Club · Usaf Academy, COBuilt 1978 · S/N 17270986 N1402SJohnston Matthew A · Ventura, CABuilt 1976 · S/N 18264962 N1402XRegistration Pending · Oakwood, OHRegistration pendingBuilt 1985 · S/N 24 N14033Nomadic Flight Training LLC · New Castle, DES/N 28-25388 N14038Eagle Aviation And Logistics LLC · Cheyenne, WYS/N 700017 N1403CPinger Kevin · Palo Alto, CABuilt 2003 · S/N 0519 N1403G1403g LLC · Wheat Ridge, COBuilt 1961 · S/N TC-227 N1403PPresby Aire LLC · Berlin, NHBuilt 1985 · S/N 32 N1403SFarnsworth Scott · Crestwood, KYBuilt 1976 · S/N 18264963 N1403VSmith Dennis A Trustee · Salem, ORBuilt 1974 · S/N 17263550 N1403ZMid America Sprayers Inc · Ulysses, KSBuilt 1985 · S/N 34 N14043Beranek James D · Cottage Grove, ORBuilt 1972 · S/N 18-8986 N14044Myron Kurt J · Elbow Lake, MNBuilt 1972 · S/N 18-8987 N14049Liberty Leasing II LLC · Melbourne, FLBuilt 1987 · S/N 48 N1404CAeroscalper LLC · Goshen, INBuilt 1977 · S/N 17702721 N1404GJkc Farm LLC · Chinook, MTBuilt 1961 · S/N D-6893 N1404PGreen Rose LLC · Swartz Creek, MIBuilt 1986 · S/N 42 N14050M & K Flying Service Inc · Hot Springs Vill, ARBuilt 1975 · S/N 857-75 N1405GLefever Larry R · Fall City, WABuilt 1961 · S/N D-6891 N1405MWilson George W · Tucson, AZBuilt 1975 · S/N 18264318 N1405SVickers David A · Douglas, GABuilt 1976 · S/N 18264965 N1405UGuardian Aerial Patrol LLC · Edmond, OKBuilt 1976 · S/N 17267075 N1405XRij Edward · Clovis, CABuilt 1975 · S/N 28-7515292 N14060Skinner Daniel R · Mount Airy, GABuilt 1964 · S/N 28-20333 N14064University Of Central Missouri · Warrensburg, MOBuilt 1972 · S/N 18-8989 N1406CMcaninch Danny Ray · Pleasant Hill, CABuilt 1977 · S/N 17702722 N1406MHeisler Jon S · Auburn, WABuilt 1954 · S/N 30851 N1406TCitabria Inc · Auburn, CABuilt 1972 · S/N 28R-7235280 N14078Tundra Aviation Inc · Casselton, NDS/N 27-4679 N1407DFlight Training Aircraft LLC · Wilmington, DEBuilt 2008 · S/N 172S10666 N1407JInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 407 N1407TAndrews University · Berrien Springs, MIBuilt 1972 · S/N 34-7250311 N1407UN R I Flying Club · Walnut Creek, CABuilt 1976 · S/N 17267077 N1407WYoder Sylvan R · Camilla, GAS/N 60382 N1407XRavotti Air LLC · Leechburg, PABuilt 1975 · S/N 28-7505224 N14089Szymanski Tadeusz · Fort Myers, FLS/N 27-4687 N1408BIasco Flight Training Inc · Redding, CABuilt 2006 · S/N 172S10429 N1408CHaworth Michael R · Riverside, CABuilt 1977 · S/N 17702723 N1408GMorris Travis T · Chandler, AZBuilt 1961 · S/N D-6892 N1408JRossi Scott J · Hallsville, TXBuilt 1975 · S/N 408 N1408TCarter Jeff · Paragould, ARS/N 28-7225505 N1409GAir Care Leasing LLC · Lamar, COBuilt 1961 · S/N TC-233 N1409TAnker Mark W · Cambridge, OHBuilt 1972 · S/N 28-7225506 N140ACApplebaugh Jeffrey · Mechanicsville, MDBuilt 1968 · S/N 28-25001 N140AKFlying Salmon LLC · Dillingham, AKS/N 7301 N140AMSuchko Paul S · Venetia, PAS/N 28-26418 N140BBMothership Enterprises LLC · Homestead, FLBuilt 2020 · S/N E-4140 N140BCN504fl LLC · Killeen, TXBuilt 1971 · S/N 28-7125313

Back to AD 2007-04-19 R1