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.

N2099Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020179 N20992Sketo Aviation LLC · Bardstown, KYBuilt 1978 · S/N 28-7990030 N2099CFrazier Jon A · Vista, CAS/N TD-276 N2099DRollins Dale G · Covington, LABuilt 2004 · S/N 17281204 N2099NMicheal Charles E · Arlington, TXBuilt 2004 · S/N 18281333 N2099QTice William · Lancaster, MABuilt 1974 · S/N 177RG0499 N2099TArrowmark LLC · Schroeder, MNBuilt 1971 · S/N 28R-7135044 N2099WInternational Air Services Inc Trustee · Carson City, NVBuilt 2000 · S/N 80438 N209ARGeery James J · North Fort Myers, FLBuilt 2007 · S/N 71261 N209ASCherokee Bill Aerovation LLC · Gainesville, GABuilt 2005 · S/N 40.554 N209BZHipple Patrick · Brecksville, OHS/N SS890830 N209CCCampbell Aviation Inc · Dutton, MTBuilt 1997 · S/N 20209 N209DBCreedon William P · Escondido, CABuilt 1971 · S/N 139 N209DPBke Air LLC · Newnan, GABuilt 1977 · S/N 17270158 N209DSMassman Enterprises LLC · River Hills, WIBuilt 2004 · S/N 40.409 N209ESSweeney Edward C · Parrish, FLBuilt 1971 · S/N 146 N209HVAnderson Scott · Salem, ORBuilt 1979 · S/N 17272302 N209JRegistered aircraftBuilt 1982 · S/N 28-8216153 N209JFStock James D · Deer Park, WABuilt 1967 · S/N 76 N209JGPotter Gary W · Abilene, TXBuilt 1987 · S/N 1 N209JMNewell George C · Lakeview, MIBuilt 2015 · S/N 40981 N209JRSweeney Edward · Parrish, FLBuilt 1971 · S/N 166 N209JSCrystal Coast Training LLC · Kinston, NCBuilt 2023 · S/N 172S13008 N209JVPlahn Paul H · Minneapolis, MNBuilt 1971 · S/N 148 N209KFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12826 N209KTMcmaster Wayne R · Jeffersonville, INBuilt 2008 · S/N 165T N209MKTampa Helicopter Services LLC · Dover, FLBuilt 2010 · S/N S2175 N209MSLand & Air Surveying Inc · Malibu, CABuilt 1988 · S/N S1303 N209MTTerrell Michael A · Canby, ORBuilt 2009 · S/N 71202 N209RGSr Aviation Inc · Sarasota, FLFirst renewal noticeBuilt 1971 · S/N 209 N209SAInternational Air Services Inc Owner Trustee · Carson City, NVS/N 22-8448 N209SCInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 28-7625115 N209SFWhitaker Alvin E · Waterloo, WIBuilt 1971 · S/N 142 N209SHPark West Air LLC · Coraopolis, PABuilt 2007 · S/N 4256 N209WAPatstone Arthur · Port Orange, FLFirst renewal noticeBuilt 1971 · S/N 122 N20ALilbit Industries LLC · Oklahoma City, OKBuilt 1955 · S/N 23-396 N20AAGrand River Aviation LLC · Kremmling, COBuilt 1968 · S/N 17256596 N20AJTwigg Brett · Lincoln, ALBuilt 1985 · S/N 475 N20AKAuer Matthew J · Anchorage, AKBuilt 2005 · S/N 5771 N20ALHarrington Mark · West Milford, NJBuilt 1991 · S/N 46 N20AVRocco Leroy · Ceresco, MIBuilt 1976 · S/N 177RG-0888 N20AXHehmann Richard J · Belleville, ILS/N 177RG1160 N20AZDelta Juliet Wings LLC · Kennesaw, GABuilt 1979 · S/N 28-7911153 N20BGHull Matthew E · Walnut Creek, CABuilt 1984 · S/N GLODFELTY 001 N20BQAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13216 N20BUN20bu LLC · Champaign, ILBuilt 1977 · S/N 27-7754063 N20BZFirst State Aviation Services LLC · Louisburg, NCBuilt 1981 · S/N 62P08818165016 N20CEOslick Rochelle · Oxnard, CABuilt 1993 · S/N GLOVER-0001 N20CMTaylor Thomas D · Harper, TXBuilt 1951 · S/N 18-910 N20CQA-1 Heavy Equipments Corporation · Pembroke Pines, FLS/N 581

Back to AD 81-18-04 R2