Skip to content

Registered aircraft · 81,720

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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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:81-18-04-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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.

N2065POakland Helidrone Industrial LLC · Auburn Hills, MIBuilt 2002 · S/N 0140 N20660Jl Avn LLC · Ontario, OHBuilt 1973 · S/N 17261468 N20665Millais Alan K · Sacramento, CAFirst renewal noticeBuilt 1973 · S/N 17261472 N2066620666 Aircraft Leasing LLC · Spanish Fork, UTBuilt 1973 · S/N 17261473 N20667Wojtowicz Diane L · Perry, NYBuilt 1973 · S/N 17261474 N20668Safety In Motion Flight Center · Puyallup, WABuilt 1973 · S/N 17261475 N20670Stearns Edwin B Jr · Eloy, AZBuilt 1973 · S/N 17261477 N20675First Flight Corp · San Diego, CABuilt 1973 · S/N 17261482 N20676Firstflight 33 LLC · Jacksonville, FLBuilt 1973 · S/N 17261483 N2067LShort Final Aviation LLC · Siloam Springs, ARBuilt 1976 · S/N M-1866 N2067MDurant William C · Skyland, NCBuilt 2003 · S/N 60583 N20689Lessard Timothy F · Monmouth, MEBuilt 1973 · S/N 17261492 N2068SN2068s LLC · Solana Beach, CAFirst renewal noticeBuilt 1979 · S/N R18201295 N20691High Life Helicopters LLC · Kalispell, MTBuilt 2003 · S/N S1846 N20693Celestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1973 · S/N 17261494 N20697Schneidman Barry · Raleigh, NCBuilt 1973 · S/N 17261496 N206ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496036 N206BCSkelton Thomas N · Madison, MSBuilt 1999 · S/N 20608025 N206CBLewis Jeffrey R · Parker, COBuilt 1974 · S/N 28-7425230 N206CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 20608227 N206FNFlying Neutrons LLC · Lebanon, OHBuilt 1999 · S/N 20608026 N206GCCook Tyler · Seldovia, AKBuilt 2002 · S/N 20608001 N206HTPepke Mark E · Memphis, TNS/N 401 N206JAFabick John D · Saint Louis, MOBuilt 1999 · S/N 20608014 N206KMHoskins Marc R · Kennett, MOBuilt 2001 · S/N 20608153 N206KTStephens Dennis II · Lake Jackson, TXBuilt 2003 · S/N 00127 N206MCPittock Troy · Fort Worth, TXBuilt 1973 · S/N 17261461 N206MKFuhrig Austin T · Anchorage, AKBuilt 2007 · S/N MK2 N206MXFrogfeet LLC · BarcelonaBuilt 2001 · S/N 20608149 N206RGVne LLC · Dowagiac, MIBuilt 1967 · S/N 30-1427 N206SCSplashin LLC · White Lake, MIBuilt 2013 · S/N 044R N206TSchou Brice N · Thomas, OKBuilt 1953 · S/N 18-2320 N206TJSky Solutions LLC · Detroit, MIBuilt 2006 · S/N 11097 N206TVHpfm Inc · Vermillion, SDBuilt 1974 · S/N MB-660 N206ZB16d LLC · Vashon, WABuilt 2006 · S/N 20608276 N20707Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12562 N2070MD&L Aviations LLC · Breckenridge, TXBuilt 1977 · S/N 28-7890226 N20711Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12563 N20714All American Aviation Services Inc · Wilmington, NCS/N 17263816 N20716Sargent Philip R · North Scituate, RIBuilt 1974 · S/N 17263817 N2071BTrulson Gary S · Edgerton, WIBuilt 1978 · S/N M-2099 N2071LDelong Scott R · Punta Gorda, FLBuilt 2004 · S/N 70412 N2071PAviation Business Corp · Saint Louis, MOBuilt 1956 · S/N 23-658 N2071RHughes Audie D · Starkville, MSS/N 28-5452 N2071XLyons Warren C · Hershey, PABuilt 1995 · S/N CFS001 N20727Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12577 N20729Di Ludovico Leonard P · Leetonia, OHBuilt 1974 · S/N 17263821 N2072QMeenk Regna L · Las Vegas, NVS/N 177RG0472 N2072SKelty Joel P · Portland, ORBuilt 1979 · S/N R18201298 N2072TAshby Darrell · Elko, MNBuilt 1970 · S/N 28R-7135016

Back to AD 81-18-04 R2