Skip to content

Registered aircraft · 630

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:87-11-01-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:87-11-01-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:87-11-01-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:87-11-01-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:87-11-01-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:87-11-01-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.

N93622Dionne Jason · Madison, SDS/N 73-30582 N93623Lausevic Daniel · Rancho Cordova, CABuilt 1974 · S/N 74-30718 N93625Stewart Richard Lynn · Birmingham, ALBuilt 1973 · S/N 73-30570 N93626Ham Erol M Jr · Augusta, GABuilt 1973 · S/N 74-30618 N93641Krikorian Stephen H · Centennial, COBuilt 1973 · S/N 74-31073 N93657Jewett Lucas D · Helena, MTS/N 76-31123 N93671Dorrance John Christian · Washington, DCS/N 74-30677 N93675Rose Gary A · Brighton, TNBuilt 1974 · S/N 74-30706 N93698Shealey Burnet D Jr · Landrum, SCBuilt 1974 · S/N 74-30689 N936MKanig Stephen · Albuquerque, NMS/N 93-301019 N93710Obrian Brandon · Travelers Rest, SCS/N 73-32-121 N93714Sprunger Air Services Div Of · Dalton, OHS/N 74-30627 N93743Leonards Exchange Portrait Studio Inc · Saint Augustine, FLBuilt 1973 · S/N 73-30569 N93759Billingsley Rod A · Las Vegas, NMBuilt 1973 · S/N 73-30573 N944EMHodges Gail A · Fruitland Park, FLS/N 73-30583 N9505EKelso Ted M · Fort Worth, TXBuilt 1975 · S/N 75-32-159 N9516ESabo John D · New Lenox, ILBuilt 1976 · S/N 76-31133 N9517ESlail Fahmi Y · Beaverton, ORBuilt 1975 · S/N 75-30774 N9521ESchmidt Sanford V · Kingsville, MDBuilt 1976 · S/N 76-30832 N9522EGraham Xochitl L · Los Lunas, NMBuilt 1976 · S/N 76-31134 N9525EKern George R · Topeka, KSBuilt 1976 · S/N 76-30839 N9531ECook Larry L · Dongola, ILBuilt 1975 · S/N 75-30793 N9534EBorscht Inc · Valley View, PABuilt 1975 · S/N 76-30803 N9550EDickens James R · Diboll, TXBuilt 1975 · S/N 75-31114 N9551ECrosby David J · Potomac, MDBuilt 1977 · S/N 77-30853 N9553EWatson Glenn G · Lancaster, CABuilt 1976 · S/N 76-30830 N9554EHosteller Samuel R · Plains, MTBuilt 1977 · S/N 78-30862 N9558ERussell John Kenneth Sr · Graford, TXBuilt 1975 · S/N 76-30798 N9577EWeinrich Stanley Craig · Saint Augustine, FLBuilt 1976 · S/N 76-30837 N9578ENorton Tim C · Danville, VAS/N 76-31130 N9582EDsm Aviation Financing LLC · Dallas, TXBuilt 1978 · S/N 78-30866 N9587EFaber Theodore V · Culver City, CAS/N 77-32-170 N9591ELonas Hal C · Carlsbad, CAS/N 76-30843 N9596EKingaire LLC · Panama City, FLS/N 77-32-171 N9597EEwart Scott J · Fallon, NVBuilt 1978 · S/N 78-30899 N9601ETrant David B · Kingsville, TXBuilt 1976 · S/N 76-30826 N9602EMerrill Mark · Ellensburg, WABuilt 1976 · S/N 76-31124 N9605EMckinney James R · Saint Charles, MOBuilt 1978 · S/N 78-32-172 N9606ENeighborhood Helping Hands LLC · Mesa, AZBuilt 1976 · S/N 76-30819 N9607EBabb Clifford · Kerrville, TXBuilt 1978 · S/N 78-30869 N9610ERegistration Pending · Cashion, OKRegistration pending, canceledBuilt 1977 · S/N 77-30856 N9612EUzochi Inc DBA · Santa Fe, NMBuilt 1975 · S/N 75-30768 N9613EWooding Jeremiah L · Arlington, TXBuilt 1978 · S/N 78-30884 N9622EGilpatrick Hannah W · Las Vegas, NVBuilt 1977 · S/N 77-31139 N9623EHinojosa Edward · Georgetown, TXBuilt 1976 · S/N 76-32-166 N9632ERoberts Terrell N III · Kensington, MDBuilt 1976 · S/N 76-30814 N9643EEl Gato Grande Aviation LLC · Philadelphia, PABuilt 1977 · S/N 77-32-169 N9649EN9649e LLC · Alexander, ARBuilt 1978 · S/N 78-30902 N9652EKoschara Nathaniel · Geneseo, NYBuilt 1977 · S/N 78-30863 N9653ESpruce Goose Aircraft LLC · Blaine, MNS/N 76-30834

Back to AD 87-11-01 R1