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.

N201METuttle Raland · Midland, TXBuilt 1977 · S/N 24-0166 N201MFPierce Erin Patrick · Hammond, LABuilt 1977 · S/N 24-0096 N201MHForbes Angus P · Cedarburg, WIBuilt 1976 · S/N 24-0022 N201MJFattore Ralph · Alamo, CABuilt 1977 · S/N 24-0132 N201MKMooney 201mk LLC · Tempe, AZBuilt 1977 · S/N 24-0204 N201MNWeidner Jamie A · Perrysburg, OHBuilt 1966 · S/N 1242 N201MPHamre Austin · Lafayette, COBuilt 1977 · S/N 24-0072 N201MQWarrick Carl B · Longview, TXBuilt 1977 · S/N 24-0244 N201MRBarr Roger B · Port Angeles, WABuilt 1977 · S/N 24-0167 N201MUGray John W · Hampshire, ILBuilt 1977 · S/N 24-0260 N201MVMcnulty Joseph P · Phoenix, AZBuilt 1977 · S/N 24-0381 N201MWRapid Runway LLC · Metairie, LABuilt 1977 · S/N 24-0247 N201MXRkm Air LLC · Houston, TXBuilt 1977 · S/N 24-0266 N201MYRegistered aircraftBuilt 1977 · S/N 24-0382 N201NBSale Reported · Smithfield, NCSale reportedBuilt 1977 · S/N 24-0090 N201NCSullins William S · St Simons Island, GABuilt 1977 · S/N 24-0124 N201NDThielbar Bruce A · Lake Arrowhead, CABuilt 1976 · S/N 24-0049 N201NFBig R Food Stores Inc · Thomasville, NCBuilt 1977 · S/N 24-0271 N201NGMalone Robert J · Prineville, ORBuilt 1977 · S/N 24-0253 N201NJBarnhardt Paul Brady · Madison, GABuilt 1977 · S/N 24-0252 N201NLCox James C · Kansas City, MOFirst renewal noticeBuilt 1977 · S/N 24-0273 N201NMDelta Echo LLC · Bay Head, NJBuilt 1977 · S/N 24-0275 N201NQTrevino Andres J · Lakeway, TXBuilt 1977 · S/N 24-0286 N201NREddy Bruce A · Winfield, ALBuilt 2004 · S/N 3162 N201NTRhcc Corp · Grand Lake, COBuilt 1977 · S/N 24-0133 N201NUGolden Seal Enterprises Inc · Winchester, VABuilt 1977 · S/N 24-0277 N201NVSorbi Aviation Inc · El Cajon, CABuilt 1977 · S/N 24-0294 N201NWBravo Echo LLC · Eagan, MNBuilt 1977 · S/N 24-0276 N201NXSzajer Gregory · Catskill, NYBuilt 1977 · S/N 24-0283 N201NZMooney M20j Brokers LLC · Saint Charles, MOBuilt 1977 · S/N 24-0300 N201PMarshall Christopher R · Oshkosh, WIBuilt 1976 · S/N 240070 N201PBHumphrey Richard Ingraham · Keller, TXBuilt 1977 · S/N 24-0146 N201PCGreatest Show Management LLC · Bee Cave, TXBuilt 1977 · S/N 24-0083 N201PDOlmstead Cecil Jay III · Houston, TXBuilt 1977 · S/N 24-0170 N201PFMooney Flyers LLC · Minot, NDBuilt 1977 · S/N 24-0145 N201PJBrownfield Izzy · Denton, TXBuilt 1977 · S/N 24-0180 N201PKMininger John · Quakertown, PABuilt 1977 · S/N 24-0278 N201PNAkins Anthony · Meridian, IDBuilt 1977 · S/N 24-0302 N201PPRohrbach James S · Fort Lauderdale, FLBuilt 1979 · S/N 24-0846 N201PSEmbrey Matthew D · Murrieta, CABuilt 1977 · S/N 24-0113 N201PTWells Tony · Knob Lick, KYBuilt 1977 · S/N 24-0106 N201PVCowan George L · Scranton, SCBuilt 1977 · S/N 24-0321 N201PXNecessary Richard A Jr · Rural Hall, NCBuilt 1977 · S/N 24-0315 N201PYRandolph Paul D · Easley, SCS/N 24-0310 N201PZSmits Joel R · Crete, ILBuilt 1977 · S/N 240329 N201QAIron Wing Flying Club Inc · Shelby Township, MIBuilt 1977 · S/N 24-0317 N201QBQuattlebaum Kevin R · High Rolls, NMBuilt 1979 · S/N 240895 N201QCDigital Outdoor Adertising LLC · Reno, NVS/N 24-0305 N201QEWaters Michael C · Social Circle, GABuilt 1977 · S/N 24-0343 N201QHPodd Bradley Stephen · Wilmington, NCBuilt 1977 · S/N 24-0348

Back to AD 81-18-04 R2