Skip to content

Registered aircraft · 1,108

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:73-07-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-07-07') 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:73-07-07')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-07-07')
  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:73-07-07')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-07-07')
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 N1009QWatson James E Jr · Victor, COBuilt 1962 · S/N 310H0009 N1011SAfrican American Airlines Inc · Brandon, FLBuilt 1964 · S/N 310I0092 N1015QMayo William J Jr · Reed Point, MTBuilt 1962 · S/N 310H0015 N102JRRutkosky John J DBA · Palm Coast, FLBuilt 1961 · S/N 310-0041 N102XRidley Benjamin · Jamesville, NYBuilt 1966 · S/N 310L-0034 N103DTPrescott Stephen I · Cornish, MES/N 320B0004 N103EMSjm Aero LLC · Winter Haven, FLS/N 310R0083 N103FSHannah Lonnie · Williamson, WVBuilt 1979 · S/N 310R1834 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 N105LRegistered aircraftBuilt 1959 · S/N 35981 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 N10BDCalkins Mark E · Longview, TXBuilt 1978 · S/N 310R1539 N10KMJohnson Walter N · Hico, TXS/N 310I0101 N10PRVillalobos Jesus F · Farmington, NMBuilt 1961 · S/N 310-0032 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 N111EAExecutive Air Inc · Roanoke, VAS/N 310R0245 N111NCDaxair Aviation LLC · Scottsdale, AZBuilt 1975 · S/N 310R0182 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 N113KKolstad Christopher Van · Galata, MTBuilt 1975 · S/N 310R0107 N114AMLon Air LLC · Longwood, FLBuilt 1977 · S/N 310R0887 N117JDVintage Motors Inc · Beattyville, KYBuilt 1967 · S/N 310L-0167 N117WWNowak Jerome S · Elmhurst, ILS/N 320D0096 N1181FPatel Jayesh V · Titusville, FLBuilt 1959 · S/N 35971 N1188Persky Adam · New Bern, NCBuilt 1960 · S/N 39152 N1189MQuality Aviation Inc · Marana, AZS/N 39180 N11GXWestrum Enterprises LLC · Norwalk, IABuilt 1976 · S/N 310R0645 N11SLJohnson Randy L · Pikeville, KYBuilt 1960 · S/N 310-0029 N11TJKubic Daniel W · Advance, NCBuilt 1979 · S/N 310R1683 N1203WPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1980 · S/N 310R-2106

Back to AD 73-07-07