Registered aircraft · 108,433

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.

N220ECCc Landscaping Warehouse Plus Inc · Bradenton, FLBuilt 2022 · S/N 14586 N220EPLeyva Jose Luis · New Smyrna Beach, FLBuilt 1985 · S/N 172-76484 N220EXRodriguez Henry Solano · Charlotte, NCBuilt 2010 · S/N 97143 N220FLChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 4496479 N220FTTechnical Education Services Inc T/A · Virginia Beach, VABuilt 1989 · S/N 1093 N220GBryant Tyrone L · Bigfork, MTS/N D-6657 N220GDJoseph M De Lecce Trustee · Prather, CAS/N 414A0459 N220GGHill Robert W · San Jose, CABuilt 2009 · S/N 12820 N220HDAce Transport Service Inc · Wilmington, DEBuilt 1975 · S/N 310R0593 N220JAHogan Field Hangars LLC · Fairfield, OHBuilt 1984 · S/N 172-76157 N220JGArchies Wings LLC · Umatilla, FLBuilt 1978 · S/N 28-7990067 N220JWFirst Eagle Inc · Wilmington, DEBuilt 1997 · S/N G2001024 N220MEBoyle Flying Service Inc · Boyle, MSBuilt 1967 · S/N U206-0797 N220MFMontana Motor Cars LLC · Kalispell, MTBuilt 2002 · S/N 0022 N220MGCornwell Anne L · Athens, OHBuilt 1978 · S/N 28R-7837156 N220MMMiranda Jon · El Dorado Hills, CABuilt 2001 · S/N 279 N220MWLampert Aviation LLC · Phoenix, AZBuilt 1977 · S/N E-1063 N220NXPendley Timothy · Madera, CAS/N 200002 N220NYCa Aviation 172 LLC · Santa Barbara, CABuilt 1974 · S/N 17263763 N220RBParker Rob · Yukon, OKS/N 3147 N220RFUninsured N220rf LLC · Jacksonville, FLBuilt 2002 · S/N 22814 N220RLNichols Michael A · Fredericksburg, VABuilt 2019 · S/N 171 N220RPDanzig Peter B · Menlo Park, CABuilt 1988 · S/N E-2438 N220SGExecutive Helicopters Inc · Myrtle Beach, SCBuilt 2004 · S/N 10220 N220SRBriar Flyer LLC · Bedford, NHBuilt 2002 · S/N 0391 N220SWBas Part Sales LLC · Greeley, COBuilt 2016 · S/N 14013 N220TAAircraft Partner Holdings Inc Trustee · BerlinBuilt 1988 · S/N 5134 N220TBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 11445 N220TCLanger Brent A · Owatonna, MNBuilt 1973 · S/N 18502153 N220TJJaco Oil Co · Bakersfield, CAS/N 21063139 N220VStartz John D · Dallas, TXBuilt 1969 · S/N TC-1235 N220WBWells Propane Inc · Wells, NVBuilt 1974 · S/N 210-60194 N220WMUtah Helicopter LLC · Spanish Fork, UTBuilt 2005 · S/N 3815 N220WRExecutive Services Inc · Columbus, MSBuilt 1994 · S/N E-2909 N220WSClark Alan R · Tucson, AZBuilt 1978 · S/N R18200260 N220WXMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881540 N22101Propwash Aviation LLC · Midland, MIBuilt 1974 · S/N 17264055 N2210LStefanov Mark · Georgetown, TXBuilt 1976 · S/N MC-441 N2210RCarroll James K · Paso Robles, CAS/N T210-0360 N2210XDraco Flight School DBA · Chino, CABuilt 1979 · S/N 28-7916351 N2210YN2210y LLC · San Antonio, TXBuilt 2000 · S/N 29-0212 N2211CChampigny Jean-Pierre · Harrison, NYBuilt 1982 · S/N 28-8290097 N2211EDe La Osa Jorge · Treasure Island, FLBuilt 1978 · S/N 28-7911045 N2211FSkyvault Holdings LLC · Saint Petersburg, FLBuilt 1960 · S/N 39235 N2211GKoepplin Ricky G · Missoula, MTBuilt 1958 · S/N 51511 N2211JEpstein Adam S · Milford, MABuilt 1978 · S/N 28-7911066 N2211UHooten Joshua C · Heber Springs, ARS/N 32R-7985090 N2211WTucker Christian Taylor · Butler, MOBuilt 1964 · S/N 2875 N2211YGayle Randall K · Houston, TXBuilt 1967 · S/N 17700011 N2211ZN2211z LLC · Lake Worth, FLBuilt 1979 · S/N 28-7916389

Back to AD 2007-04-19 R1