Registered aircraft · 13,306

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

N2293FTwo Mile High Mining LLC · Victor, COBuilt 1970 · S/N 414-0097 N2293JFrey Jerry P · Fallon, NVBuilt 1979 · S/N T18803449T N2295RDuhl James R · Roseville, MNFirst renewal noticeBuilt 1969 · S/N T210-0445 N2296RCelias Food Corp · Miami, FLS/N T210-0446 N2298EUberoy Pawan · Pleasanton, CABuilt 1997 · S/N E3138 N229ATN312sp LLC · Glen Allen, VABuilt 2024 · S/N 10030 N229DTEyes In The Skies LLC · Oklahoma City, OKBuilt 2012 · S/N 3850 N229DWSpringline Ventures LLC · Orlando, FLBuilt 2024 · S/N 10319 N229FSmith Dennis L · Burbank, CABuilt 2006 · S/N 2299 N229FDN229fd LLC · Myrtle Beach, SCBuilt 2025 · S/N 10399 N229GMThibault Thomas N · Granbury, TXBuilt 2012 · S/N LIV-386 N229HN35ta LLC · Boxford, MABuilt 2024 · S/N 9830 N229LSLss Leasing LLC · Thomasville, GABuilt 2026 · S/N 11350 N229RHMew Enterprises LLC · Imperial, NEBuilt 2015 · S/N 1113 N229RMMjt Real Estate Holdings LLC · Orlando, FLBuilt 2002 · S/N 0416 N229SG229sc LLC · Fayetteville, GABuilt 2006 · S/N 1956 N229TXTango Xray Aviation LLC · Logan, UTFirst renewal noticeBuilt 2011 · S/N 0076 N229VAGerrard Roger I · Repton, ALBuilt 2020 · S/N XLR5-101 N229WARoyal Skies LLC · Yakima, WABuilt 2013 · S/N 0616 N22ABKimhi Transportation LLC · Woodland Hills, CABuilt 2015 · S/N 1144 N22ADMorganav Inc · Chapel Hill, NCBuilt 2018 · S/N 4641 N22AMJays Aircraft Maintenance Inc · Costa Mesa, CABuilt 1979 · S/N 310R1634 N22AYRegistration Pending · Lebanon, PARegistration pendingBuilt 2004 · S/N 1176 N22CAN22ca LLC · Ennis, MTBuilt 2008 · S/N 421003 N22CCLegacy Air LLC · Oklahoma City, OKBuilt 1984 · S/N TJ-471 N22CE0 To 100 Aviation LLC · Palmetto Bay, FLBuilt 2020 · S/N 4918 N22CWFoxy Investments LLC · Alpine, WYBuilt 2013 · S/N 0601 N22CYHughes Jason David · Hickory, NCBuilt 2008 · S/N 3085 N22DBSalisbury Mark J · Green Cove Springs, FLBuilt 2002 · S/N 0205 N22DGSeequs Inc · Greenwood Village, COBuilt 2023 · S/N 9229 N22DMM1 Aviation LLC · Trenton, NJFirst renewal noticeBuilt 2007 · S/N 2886 N22EGEsm Aviation LLC · Pomona, NYBuilt 2006 · S/N 2234 N22EPRobinson Michael · Tucson, AZBuilt 1972 · S/N 21059773 N22FARosen Barry W · West Hollywood, CABuilt 2003 · S/N 0782 N22GBHolland Kenneth F Trustee · Santa Clarita, CABuilt 1977 · S/N 310R1237 N22GHCorbusier James J · Monkton, MDBuilt 2005 · S/N E-3640 N22GXKiser Raymond Paul · Sebring, FLBuilt 2004 · S/N 0980 N22KHTrue Aviation LLC · Charlottesville, VABuilt 2002 · S/N 0198 N22KMTorris Warren E · San Dimas, CABuilt 1973 · S/N 21060132 N22LJ&J Aircraft Holdings LLC · Vonore, TNBuilt 2017 · S/N 1489 N22MSWolf Aviation LLC · Baltimore, MDBuilt 2020 · S/N 2080 N22MXAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2026 · S/N 11123 N22NRJefferson Aviation LLC · Seville, OHBuilt 1974 · S/N 4140497 N22PAffinity Air LLC · Fort Worth, TXBuilt 2016 · S/N 1369 N22PDSalt River Ventures LLC · Missoula, MTBuilt 2020 · S/N 2119 N22RTSchuppan Goetz N · Edmond, OKBuilt 2020 · S/N 2098 N22SAAerowest LLC · Independence, ORBuilt 2011 · S/N LIV-409 N22SKLiddiard Bryan J · Mesa, AZBuilt 2022 · S/N 8801 N22TLRiehm Management LLC · Beverly Hills, CABuilt 2021 · S/N 2250 N22TMN22tm LLC · Wales, WIBuilt 2025 · S/N 10433

Back to AD 2012-10-13