Skip to content

Registered aircraft · 26,232

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

N6044PRainier Flight Service LLC · Renton, WABuilt 2011 · S/N 16200171 N6044RLee Brett · Austin, TXBuilt 1965 · S/N 17253713 N6045AFleischman Matthew A · Moab, UTBuilt 1956 · S/N 28645 N6045GWalls Sales LLC · Poplar Bluff, MOBuilt 1969 · S/N 15071545 N6045TSaladino Michael J · Metairie, LABuilt 1964 · S/N 15060745 N6045VLee Levi A · East Gull Lake, MNS/N 7BCM-273 N60463Angeltown LLC · Covina, CABuilt 1969 · S/N 15070326 N6046ADickerson Danny W · York, SCBuilt 1956 · S/N 28646 N6046KAl-Rubaiie Haider A · Fort Worth, TXBuilt 1975 · S/N 15077494 N6046TDimaio Joseph V · Leesville, LABuilt 1964 · S/N 15060746 N6046ZSale Reported · Lynn Haven, FLSale reportedBuilt 2011 · S/N 16200177 N60470Lowry John R · Mexico, MOBuilt 1969 · S/N 15070333 N60471Tiger Capital LLC · Helena, MTBuilt 2011 · S/N 16200178 N60474Koeck Max IV · Metairie, LAS/N 15070337 N60475Blair Shawn C · Mandeville, LABuilt 1969 · S/N 15070338 N60477Edwards Blake A · Greensburg, KYS/N 15070340 N6047AJames Theodore B · Marine St Crx, MNS/N 28647 N6047RSwanson Brad J · Yakutat, AKBuilt 1965 · S/N 17253716 N60484Erb Charles A · Holden, MEBuilt 1969 · S/N 15070344 N60487Mac Mor Ltd · East Troy, WIBuilt 1969 · S/N 15070347 N6048JAll Elements Aviation LLC · Newnan, GABuilt 1972 · S/N A1500348 N6048UN6048u LLC · Manassas, VABuilt 2011 · S/N 16200182 N60492Saint John Harold James · Arvada, COBuilt 1969 · S/N 15070350 N60494Heilmann Charli E · Martinsburg, WVBuilt 1969 · S/N 15070352 N60499Marion Military Institute · Marion, ALBuilt 1969 · S/N 15070355 N6049AMetcalf Nate J · Hooker, OKBuilt 1956 · S/N 28649 N6049JKyne James M Jr · Vacaville, CABuilt 1972 · S/N A1500349 N6049RSmith Timothy John · Parkville, MDBuilt 1965 · S/N 17253718 N6049XWings Air Charter LLC · Wisconsin Rapids, WIBuilt 2011 · S/N 16200183 N60502Janak Jeffrey J · Corpus Christi, TXBuilt 1969 · S/N 15070356 N60505Mcbride Kristi L · Lexington, OKBuilt 1969 · S/N 15070359 N60506Bludworth Richard W Jr · Katy, TXS/N 16200184 N60507Pilot Training Center LLC · Miami, FLBuilt 2011 · S/N 16200185 N60509Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1969 · S/N 15070361 N6050ACorsair Aviation LLC · Pacoima, CABuilt 2011 · S/N 16200186 N6050BAir-Ric LLC · Mobile, ALS/N 16200187 N6050GNihan Gregory K · Hanson, MABuilt 1969 · S/N 15071550 N60510Hansen Larry G · Alliance, NEBuilt 1969 · S/N 15070362 N60515Ristevski Bill · Vacaville, CABuilt 1969 · S/N 15070365 N6051ABlair Marion J · Lafayette, LABuilt 1956 · S/N 28651 N6051JRobison David · El Dorado, ARBuilt 1972 · S/N A1500351 N6051KC K Leasing Services LLC · Wilmington, DEBuilt 2011 · S/N 16200190 N60522Red Sky Aviation LLC · Livermore, CABuilt 1969 · S/N 15070372 N60524Rainier Flight Service LLC · Renton, WABuilt 2011 · S/N 16200192 N6052APhillips Roberta L · Riverside, CABuilt 1956 · S/N 28652 N6052FM & N Airventure Inc · Wilmington, DEBuilt 2011 · S/N 16200193 N6052KCollins Robert E · Belleville, ILBuilt 1975 · S/N 15077496 N60532Duffy James F · Hudson, WIBuilt 1969 · S/N 15070379 N60538Needs Nichole R · Granger, IAS/N 15070384 N6053ABalazs Marguerite · Devine, TXS/N 28653

Back to AD 94-05-05 R1