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.

N1671RDavis Ronald L Jr · Soldotna, AKBuilt 1974 · S/N 18502394 N1671WAviatech Inc · Tamarac, FLBuilt 1972 · S/N D-9382 N16727Armstrong Bernard A · Cerrillos, NMBuilt 1969 · S/N MB-444 N1672CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11760 N1672EWichita Area Technical College · Wichita, KSBuilt 1978 · S/N 17271089 N1672PAkchak Air LLC · Leeds, UTBuilt 1954 · S/N 18-3801 N1672RBriggs Donald L · Santa Barbara, CABuilt 1978 · S/N R18200507 N1673CCe-172 Aircraft LLC · Wilmington, DEBuilt 2012 · S/N 172S11761 N1673EHusband Thomas W · Bigfork, MTBuilt 1978 · S/N 17271090 N1673JSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1967 · S/N 28-24074 N1673MBower Ashley R · Anchorage, AKBuilt 1971 · S/N 18501865 N1673RGregory John F · Emmitsburg, MDBuilt 1978 · S/N R18200508 N1673THarvey Alan G · Dallas, TXBuilt 1981 · S/N E-1895 N1673WOci Ltd · Brunswick, GABuilt 1972 · S/N TH-258 N1674CFarwest Aviation LLC · Billings, MTBuilt 1953 · S/N 30374 N1674EMedary Aviation LLC · Brookings, SDBuilt 2005 · S/N 172S9915 N1674JCaloon John H · Greenfield, MABuilt 1968 · S/N 28-24075 N1674VAbraham Elizabeth J · Browntown, WIBuilt 1974 · S/N 17263709 N1674WLipps Charles J · Fairview, OKBuilt 1972 · S/N CD-1298 N1675GKraft Jesse · Twain Harte, CAS/N 130 N1675HIcarus Flying Academy LLC · Farmingdale, NYBuilt 1977 · S/N 28-7716040 N1675JTevis Aviation Inc · Emporia, KSBuilt 1967 · S/N 28-24076 N1675MWenk Peter J · Ocala, FLBuilt 1971 · S/N 18501867 N1675WHarper Jerad Vincent · Windsor, CAS/N CE-398 N1675XNo Runways LLC · Iraan, TXBuilt 1975 · S/N 21060710 N1676CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11762 N1676GCain Landa B · San Diego, CAS/N 131 N1676RBlue Side Up LLC · Elbert, COBuilt 1978 · S/N R18200510 N1676UDigicam Co · Henderson, NVBuilt 1982 · S/N 21064724 N1676WTrask Barrett Lee III · Matthews, NCBuilt 1972 · S/N CD-1299 N1676XSkydancer Le LLC · Wilmington, DEBuilt 1975 · S/N 21060711 N1677CDavis Aero LLC · Incline Village, NVBuilt 1953 · S/N 30377 N1677JCross X Country LLC · Great Falls, VABuilt 1968 · S/N 28-24078 N1677RYarger Denim B · Laurel, MTBuilt 1974 · S/N 185-02400 N1677WLagrow II LLC · Coloma, MIBuilt 1973 · S/N CE-419 N16789Smith Stephen · Annandale, VABuilt 2005 · S/N 172S9916 N1678CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11763 N1678HBrown Gregory B · New London, CTBuilt 1977 · S/N 28-7790330 N1678JCloudhoppers Inc · Effingham, ILBuilt 1967 · S/N 28-24079 N1678RPureflight Aviation Training LLC · Newberg, ORBuilt 1974 · S/N 18502401 N1678TGabaldon Martin · El Paso, TXS/N 414-0471 N1678XFly Guys LLC · Arcata, CABuilt 1975 · S/N 21060713 N1678ZLongmire Dale · Senoia, GABuilt 1962 · S/N 1850470 N1679MVaughns Flying Service Inc · Reese, MIBuilt 1971 · S/N 18501870 N1679PClearwater Potlatch Timber Pa · Orofino, IDBuilt 1954 · S/N 18-4068 N1679XBouchereau Raymond Jr · San Dimas, CABuilt 1975 · S/N 21060714 N1679ZRiemer Emil F · Brush Prairie, WABuilt 1962 · S/N 185-0479 N167AMVandeventer Larry D · Charlotte, NCBuilt 1999 · S/N 23163 N167AWPlane Fun Inc Tr Trustee · Snellville, GABuilt 1978 · S/N 340A0537 N167BHHolliday Robert R · Andover, KSBuilt 1966 · S/N 17255345

Back to AD 2007-04-19 R1