Skip to content

Registered aircraft · 81,733

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.

N431CRAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11454 N431DEClark Air Ventures LLC · Awendaw, SCBuilt 2002 · S/N 40.232 N431ERegistration Pending · Kokomo, INRegistration pendingBuilt 2007 · S/N 70423 N431EAHamilton Dale N · Grand Rapids, MIBuilt 1991 · S/N 05 N431FDahlin Joel R · Saint Paul, MNBuilt 1968 · S/N 28-24929 N431FPSky West Aviation Inc Trustee · Albuquerque, NMS/N 172S9431 N431JDeboer Jon Tanner · Saginaw, TXBuilt 1994 · S/N 431 N431JPJoerithan & Mp Aviation LLC · Whittier, CABuilt 2004 · S/N 40.431 N431KPPietsch Kent D · Burlington, NDBuilt 2020 · S/N SA2281X N431MARegent Trust Corporation Trustee · Wichita, KSBuilt 2022 · S/N 1200-2022 N431NSSarkinen Scott W · Amboy, WABuilt 2026 · S/N P412 N431RAJimenez Raymond C · Gardena, CABuilt 1990 · S/N 31 N431RMPierzchalski Aidan K · Stevenson Ranch, CABuilt 2004 · S/N 2843600 N431SAArgotsinger Michael · Wichita, KSBuilt 2004 · S/N 952-2004 N431SMPongracz Brian · Redding, CABuilt 2002 · S/N 90409 N431SSSmith Simon K · Janesville, WIBuilt 2007 · S/N 555R N431WRettenmaier Kim J · Columbia, MOBuilt 1969 · S/N 28R-35277 N43200Robertson Charles V II · Amarillo, TXFirst renewal noticeBuilt 1974 · S/N 28-7425344 N43201Paul Richard · Fresno, CAS/N 28-7415443 N43206Hower Phillip G · Seabeck, WABuilt 1974 · S/N 28-7415444 N43208Thornburgh Paul J Trustee · Sun Prairie, WIBuilt 1974 · S/N 28-7415445 N4320AKnutson Daniel T · Lodi, WIS/N 22-3672 N4320FSkippys Sky Scooter LLC · Jenks, OKBuilt 1976 · S/N 28-7715016 N4320JHaddle Eddie · Lindon, UTBuilt 1967 · S/N 28-22694 N4320MKoinzan Flying Service Inc · Elgin, NEBuilt 1947 · S/N 12-3256 N4320TBsrp III LLC · Hickory, NCBuilt 1988 · S/N 3213014 N4320ZSchermerhorn Lee V D III · Oak Harbor, WABuilt 1968 · S/N 18-8633 N43214Bellard Cedric · Valrico, FLBuilt 1974 · S/N 28-7415446 N43215Gremel Tyler · Ellensburg, WABuilt 1974 · S/N 28R-7435254 N43218On Final Aviation LLC · Brookland, ARBuilt 1974 · S/N 28-7425345 N43219Stading William T · Hackensack, MNBuilt 1974 · S/N 28-7415447 N4321BRegistered aircraftBuilt 1971 · S/N 119 N4321FVales Louis · Monroe, NYBuilt 1976 · S/N 28R-7635455 N4321JN51343 LLC · Newnan, GABuilt 1967 · S/N 28-22695 N4321QW H Flying Club Inc · Kingston, MIS/N 17260221 N4321TSale Reported · Signal Hill, CASale reportedBuilt 1971 · S/N 28R-7235007 N4321YSchuermann Chris L · Sand Springs, OKBuilt 1965 · S/N 27-607 N43221Bednarz Joseph P · Hendersonville, TNBuilt 1974 · S/N 28-7405181 N43224Piper Aviation LLC · Tierra Verde, FLBuilt 1974 · S/N 28-7425346 N4322FAdk Xc Flyers LLC · Scotia, NYBuilt 1976 · S/N 28R-7635456 N4322GMid Atlantic Air Museum · Reading, PABuilt 1971 · S/N 032 N4322JDougherty Joseph P · Hughesville, PABuilt 1967 · S/N 28-22696 N4322MVeal Jeffrey S · Sterling, AKS/N 12-3257 N4322RKing Air Charter LLC · Zanesville, OHBuilt 1978 · S/N R18200590 N4322XManitowoc Flyers Corp · Manitowoc, WIBuilt 1975 · S/N 28-7690015 N4322ZLee Gerald R · Glennallen, AKBuilt 1968 · S/N 18-8636 N43232N43232 LLC · Orange, TXBuilt 1974 · S/N 28-7415450 N43234Level Up Aviation LLC · Newton, ALBuilt 1974 · S/N 28-7415451 N4323HRucker Edward A · Longview, TXS/N 24-0704 N4323QWausau Flying Service Inc · Wausau, WIBuilt 1971 · S/N 17260223

Back to AD 81-18-04 R2