Skip to content

Registered aircraft · 688

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

N1000NAnderson Aerial Spraying Service Inc · Canby, MNBuilt 1963 · S/N 310H0104 N1000QErnest Obregon · Oakley, CAS/N 310P0195 N1001QRegistered aircraftBuilt 1962 · S/N 310H0001 N1002QSwanson Dale A · Nashua, NHBuilt 1962 · S/N 310H0002 N1005QRegistration Pending · Fairmont, WVRegistration pendingS/N 310H0005 N1008AAerial Surveys International LLC · Watkins, COBuilt 1967 · S/N 402-0097 N1009QWatson James E Jr · Victor, COBuilt 1962 · S/N 310H0009 N100JLBytelogics Inc · New York, NYS/N 421-0008 N1011SAfrican American Airlines Inc · Brandon, FLBuilt 1964 · S/N 310I0092 N1015QMayo William J Jr · Reed Point, MTBuilt 1962 · S/N 310H0015 N101MEIbs America Corp · Wilmington, DEBuilt 1969 · S/N 401A0130 N1027DRobins Jack S · Saint Charles, IDBuilt 1968 · S/N 421-0196 N102XRidley Benjamin · Jamesville, NYBuilt 1966 · S/N 310L-0034 N103DTPrescott Stephen I · Cornish, MES/N 320B0004 N103ECAerial Surveys International LLC · Watkins, COBuilt 1967 · S/N 401-0135 N1045QWolf Mark W · Long Lake, MNBuilt 1963 · S/N 310H0045 N1046QAcharya Jay P · Powell Butte, ORS/N 310H0046 N1052QNighthawk Air Systems Inc · Miami, FLS/N 310H0052 N1056QAerotrack Inc · Hemet, CABuilt 1963 · S/N 310H0056 N105BCKlauber Robert A · Athens, TNBuilt 1966 · S/N 310K0232 N105KAGillespie Todd · Trenton, SCS/N 401-0238 N105MCMathison John M · Del Norte, COBuilt 1964 · S/N 310I0162 N1073QRegistration Pending · Polo, MORegistration pendingBuilt 1963 · S/N 310H0073 N1079QGriffin Marcus · Houston, TXBuilt 1963 · S/N 310H0079 N1083QAhlhorn Travis W · San Marcos, TXBuilt 1963 · S/N 310H0083 N10AAPeterson Andrew · Louisville, KYBuilt 1966 · S/N 320E0046 N10KMJohnson Walter N · Hico, TXS/N 310I0101 N1103QHenderson Phillip Kimon III · Benton Harbor, MIBuilt 1963 · S/N 310H0103 N1105QSundale Aviation Inc · Erwinna, PABuilt 1963 · S/N 310H0105 N1106QOrellana Wilson · Hesperia, CAS/N 310H0106 N1107QValiair Limited Co Trustee · Casper, WYBuilt 1963 · S/N 310H0107 N1112QLastowski Gerald J · Gulf Breeze, FLBuilt 1963 · S/N 310H0112 N1119QKeeton Andrew · Palestine, TXBuilt 1963 · S/N 310H0119 N111SDMarc Inc · Bolton, MSBuilt 1969 · S/N 310P0200 N111XBoone Aviation Ltd · Denver, COBuilt 1965 · S/N 310J0108 N1121QTwomey Kieran S · Coronado, CABuilt 1963 · S/N 310H0121 N1129QTippecanoe Valley Aero Inc · Delphi, INBuilt 1963 · S/N 310H0129 N112HPBertagnole Karl R · Wright, WYBuilt 1964 · S/N 310I0104 N1133QHaggard Haley G · Springer, OKBuilt 1963 · S/N 310H0133 N117JDVintage Motors Inc · Beattyville, KYBuilt 1967 · S/N 310L-0167 N117WWNowak Jerome S · Elmhurst, ILS/N 320D0096 N125DMCallegari Gino A · Susanville, CABuilt 1966 · S/N 310K0176 N129DPSplendid Air Leasing LLC · Corpus Christi, TXS/N 310L-0006 N12KNJane Air LLC · Kalamazoo, MIBuilt 1968 · S/N 421-0130 N12QHawkes F Bryant · Lake Dallas, TXBuilt 1966 · S/N 401-0014 N12TTThoms Robert D · Clyde, MIS/N 310H0066 N12VLCrow Edward N Jr · Silverdale, WAS/N 310P0171 N1313RAztexas LLC · Valley Farms, AZS/N 310J0178 N1338UJstream Lc · Sheridan, WYBuilt 1965 · S/N 411-0105 N13BPN13bp LLC · Walla Walla, WAS/N 320D0123

Back to AD 69-14-01