Skip to content

Registered aircraft · 2,553

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:76-08-02-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-08-02-R2') 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:76-08-02-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-08-02-R2')
  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:76-08-02-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-08-02-R2')
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 N100AJN8006j LLC · Shiloh, ILBuilt 1972 · S/N 421B0322 N100ELLeading Edge Leasing LLC · Wilmington, DES/N 310Q-0688 N100HJClipper Air Inc · Tomball, TXBuilt 1974 · S/N 340-0334 N100JHSonic Aviation LLC · Carrollton, MSBuilt 1971 · S/N 310Q0421 N100JLBytelogics Inc · New York, NYS/N 421-0008 N100LLPremiere Brand Meats · Shasta Lake, CABuilt 1973 · S/N 414-0429 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 N101MEIbs America Corp · Wilmington, DEBuilt 1969 · S/N 401A0130 N1027DRobins Jack S · Saint Charles, IDBuilt 1968 · S/N 421-0196 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 N103ECAerial Surveys International LLC · Watkins, COBuilt 1967 · S/N 401-0135 N103EMSjm Aero LLC · Winter Haven, FLS/N 310R0083 N103FSHannah Lonnie · Williamson, WVBuilt 1979 · S/N 310R1834 N103RMValiair Lc Trustee · Casper, WYBuilt 1975 · S/N 310R0109 N1045QWolf Mark W · Long Lake, MNBuilt 1963 · S/N 310H0045 N1046QAcharya Jay P · Powell Butte, ORS/N 310H0046 N104WMHamilton Aviation LLC · Morehead, KYBuilt 1975 · S/N 421B0964 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 N105KAGillespie Todd · Trenton, SCS/N 401-0238 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 N107TTBpi Labs Inc · Evanston, WYBuilt 1978 · S/N 310R1345 N107YYBeezhold Terence J · Lake Stevens, WABuilt 1956 · S/N 35266 N1083QAhlhorn Travis W · San Marcos, TXBuilt 1963 · S/N 310H0083 N109CBSasser Edward Craig · Albemarle, NCBuilt 1975 · S/N 340-0533 N10AAPeterson Andrew · Louisville, KYBuilt 1966 · S/N 320E0046 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 N10XEBlaikie Thomas B · Kenner, LABuilt 1973 · S/N 340-0221 N1103QHenderson Phillip Kimon III · Benton Harbor, MIBuilt 1963 · S/N 310H0103 N1105QSundale Aviation Inc · Erwinna, PABuilt 1963 · S/N 310H0105

Back to AD 76-08-02 R2