Skip to content

Registered aircraft · 56,580

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N3051EBellingham Aviation Services LLC · Bellingham, WABuilt 1978 · S/N 17271420 N3051VMeyette Alexzander · Montague, MIBuilt 1974 · S/N 15076370 N30522Colvin Buster · Big Cabin, OKBuilt 1974 · S/N 17264142 N30524Christianson Jarrett I · Gilbert, AZBuilt 1968 · S/N 17701302 N30525Johnson Monte W · La Porte, INBuilt 1968 · S/N 17701303 N30527Boone Fliers LLC · Boone, IAS/N 17701304 N3052FHofer Belik Colleen J · Sawyer, NDBuilt 1966 · S/N 18257152 N3052U6m Aviation LLC · Pleasant Hill, MOBuilt 1963 · S/N 17250652 N3052YPingston Anthony · Plymouth, MIBuilt 1962 · S/N 18254052 N30530Banegas Jose C Zankiz · Fort Myers, FLBuilt 1973 · S/N 21059929 N3053FBirkhold Craig Alan · Napoleon, OHBuilt 1966 · S/N 18257153 N3053SStelling Kurt · Newnan, GABuilt 1967 · S/N 15066953 N3053UJ & T Aviation LLC · Nashua, NHBuilt 1963 · S/N 17250653 N3053XVoigt Richard D · La Vernia, TXBuilt 1966 · S/N 15064453 N3053YMudd Joseph A · Oakland, CABuilt 1962 · S/N 18254053 N30540Steinmetz Peter N · Tempe, AZBuilt 1968 · S/N 17701312 N30542Yatman Mark Eugene · San Anselmo, CABuilt 1968 · S/N 17701314 N30544Flying Twenty Inc · San Jose, CAS/N 17701316 N30546Brady Dennis J Jr · Chesterfield, MOBuilt 1968 · S/N 17701318 N30547Wright Thomas L · Clyde, OHBuilt 1968 · S/N 17701319 N30549Lad Custom Publishing Inc · Buford, GABuilt 1973 · S/N 21059932 N3054EPrinceton Flying Club Inc · Wilmington, DEBuilt 1978 · S/N 17271421 N3054FAirlaska LLC · Gustavus, AKS/N 18257154 N3054XHeidt Daniel A · Opelika, ALBuilt 1966 · S/N 15064454 N30553Jfe LLC · Flossmoor, ILBuilt 1968 · S/N 17701322 N30556Amundson Clyde E · Poplar Grove, ILBuilt 1968 · S/N 17701324 N30557Wilson Thomas L · Sheboygan, WIBuilt 1968 · S/N 17701325 N3055ABohl Howard M · Temecula, CABuilt 1953 · S/N 25699 N3055XChickasha Wings Inc · Chickasha, OKBuilt 1966 · S/N 15064455 N30565Flowings LLC · Orlando, FLBuilt 1968 · S/N 17701331 N30567Sale Reported · West Liberty, KYSale reportedBuilt 1968 · S/N 17701332 N3056ARegistered aircraftBuilt 1953 · S/N 25700 N3056JRegistration Pending · Jackson, MIRegistration pendingBuilt 1965 · S/N 15061156 N3056USchans Richard L Sr · New Bern, NCBuilt 1963 · S/N 17250656 N3056XSmith Chelsea R · Louisville, KYBuilt 1966 · S/N 15064456 N3056YBardack Barry L Trustee · El Cajon, CABuilt 1962 · S/N 18254056 N30570Gallacher Mark A · Salem, UTBuilt 1968 · S/N 17701333 N30571Spencer Burton D · Mchenry, ILS/N 17701334 N30574Carter Peter M · Elkhorn, WIBuilt 1969 · S/N 17701337 N30578Rhodes Michael · Jacksonville, FLBuilt 1969 · S/N 17701339 N30579Dry Creek Services LLC · Lodi, OHBuilt 1974 · S/N 17264145 N3057JGaines Von J · Hendersonville, TNBuilt 1965 · S/N 15061157 N3057QJoseph C Casey · Lufkin, TXS/N 18258057 N3057SMcabee Patrick A · Tampa, FLBuilt 1967 · S/N 15066957 N3057UDesousa Raphael · Fremont, CABuilt 1963 · S/N 17250657 N3057XSoules William P · Las Cruces, NMFirst renewal noticeS/N 15064457 N3057YJjm Aviation LLC · Newport, NCBuilt 1962 · S/N 18254057 N30583Roviaro Edward · Schererville, INBuilt 1973 · S/N 21059936 N30584New Horizons Aviation LLC · East Helena, MTBuilt 1969 · S/N 17701344 N30593Valiair Lc Trustee · Casper, WYBuilt 1973 · S/N 21059938

Back to AD 79-10-14 R1