Skip to content

Registered aircraft · 1,410

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:57-04-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:57-04-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:57-04-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:57-04-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:57-04-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:57-04-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 N1009QWatson James E Jr · Victor, COBuilt 1962 · S/N 310H0009 N100ELLeading Edge Leasing LLC · Wilmington, DES/N 310Q-0688 N100JHSonic Aviation LLC · Carrollton, MSBuilt 1971 · S/N 310Q0421 N100TGBengtson Todd · Tyler, TXBuilt 1974 · S/N 310Q1150 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 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 N105CWStone George Michael Jr Trustee · Weeki Wachee, FLBuilt 1974 · S/N 310Q-0936 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 N107YYBeezhold Terence J · Lake Stevens, WABuilt 1956 · S/N 35266 N1083QAhlhorn Travis W · San Marcos, TXBuilt 1963 · S/N 310H0083 N10BDCalkins Mark E · Longview, TXBuilt 1978 · S/N 310R1539 N10ETTech Nav LLC · Columbus, INBuilt 1971 · S/N 310Q0415 N10FCKnott Me LLC · Phoenix, AZBuilt 1973 · S/N 310Q0796 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 N110CSFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1972 · S/N 310Q0616 N1112QLastowski Gerald J · Gulf Breeze, FLBuilt 1963 · S/N 310H0112 N1113TWirthlin Donald K · Sierra Vista, AZBuilt 1957 · S/N 35561 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 N11220Southern Arkansas University Tech · Camden, ARBuilt 1957 · S/N 38037 N1129QTippecanoe Valley Aero Inc · Delphi, INBuilt 1963 · S/N 310H0129 N112HPBertagnole Karl R · Wright, WYBuilt 1964 · S/N 310I0104 N112HRFlexer Howard · Monterey Park, CAS/N 35217 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

Back to AD 57-04-01