Registered aircraft · 11,798

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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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.

N223RCSailfish Aviation LLC · Little Mountain, SCBuilt 1985 · S/N FA-58 N223TPAviapa LLC · Doylestown, PABuilt 1989 · S/N BB-1348 N224AKAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 62680 N224CCRanger Aviation LLC · Houston, TXS/N LJ-1218 N224CJEagle Aviation LLC · Hamel, MNBuilt 1997 · S/N 525-0224 N224DLHagglund Carl · Pendleton, ORBuilt 1968 · S/N E-61 N224DPBlue And Gold Aviation LLC · Marietta, OHBuilt 1991 · S/N E-2599 N224GPKen Lawler Builders Inc · Shreveport, LAS/N 560-0108 N224JL205 Flintstones LLC · Flint, MIBuilt 1995 · S/N 258279 N224KCBeasley Timber Co In · Hazlehurst, GABuilt 1985 · S/N S550-0104 N224SAIkhana Aircraft Holdings LLC · Murrieta, CABuilt 1969 · S/N 247 N225BSHsr General LLC · Weatherford, TXBuilt 2002 · S/N 560-0631 N225CMMcmillin Sce LLC · El Cajon, CAS/N FL-378 N225JWTalbot Larry · Lakewood Ranch, FLBuilt 2001 · S/N E-3418 N225PGAero 7 LLC · Doral, FLS/N 25247 N225PTCurry Construction Inc · Mattoon, ILBuilt 1981 · S/N 31T-8166032 N225SATwin Otter International Ltd · Las Vegas, NVS/N 686 N225TAN225ta LLC · Loganville, GABuilt 1970 · S/N TH-64 N22604Tarten Air Inc · Smiths Creek, MIBuilt 1978 · S/N E-1287 N2261LGaf Skyborne Aviation Ventures LLC · El Dorado Hills, CABuilt 1979 · S/N E-1535 N2264LWoolum Stephanie · Varney, WVBuilt 1976 · S/N TH-771 N226BKAvtran LLC · Clayton, MOBuilt 1993 · S/N LJ1340 N226CVMassie G2 LLC · Rocklin, CABuilt 1993 · S/N 560-0226 N2270LBas Part Sales LLC · Greeley, COBuilt 1976 · S/N E-922 N2273LLtt Flights LLC · Clinton, MOFirst renewal noticeBuilt 1976 · S/N E-925 N2274LN2274l LLC · Booneville, MSBuilt 1976 · S/N LW-213 N227DCEllen Vineyards Inc · Sanger, CABuilt 1979 · S/N LJ876 N227GHCarlen Aviation LLC · Wilmington, DEBuilt 2022 · S/N 20800688 N227LAK&A Advisors LLC · Wilmington, DEBuilt 1976 · S/N 193 N227NCCausebe LLC · Black Mountain, NCS/N FL-367 N227WWFayard Enterprises LLC · Wake Forest, NCBuilt 1966 · S/N 27 N2280BDream Flight Aviation LLC · New Fairfield, CTBuilt 1982 · S/N TH-1344 N2284LUpchurch David E · Bahama, NCBuilt 1976 · S/N E-929 N2285LN2285l Aviation LLC · Robbinsville, NJBuilt 1976 · S/N E-930 N22889Tenax Aviation LLC · Ridgeland, MSBuilt 1998 · S/N UE-314 N2289ERegistered aircraftBuilt 1997 · S/N TH-1821 N228ABLuke Stephen J Trustee · Middleboro, MABuilt 1991 · S/N E-2655 N228AJTriton Airplane Leasing LLC · Wilmington, DEBuilt 1999 · S/N FL-245 N228CKN-Flight LLC · Kenedy, TXBuilt 2003 · S/N E-3487 N228CLArdillo Nick S · Dallas, TXBuilt 1984 · S/N E-2168 N228DMStone Michael · Payson, AZBuilt 1991 · S/N E-2660 N228JHBuzzed Landing LLC · Ocean Springs, MSBuilt 1980 · S/N 421C-1006 N228NMpe Beaver LLC · Seattle, WABuilt 2020 · S/N 208B5601 N228NDNorth Dakota Dept Of Transportation · Bismarck, NDBuilt 2010 · S/N 20800520 N228PGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N 560-0310 N228RCPuro Humo Aviation LLC · Miami, FLBuilt 2005 · S/N BB-1910 N228SAMonarch Enterprises Inc · Kirkland, WABuilt 1969 · S/N 253 N228YKDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 1969 · S/N 228 N2293LLemac Aviation LLC · Mesa, AZBuilt 1976 · S/N E-971 N2296LDel Air Inc · Wilmington, DEFirst renewal noticeBuilt 1976 · S/N E-932

Back to AD 2006-16-18 R1