Skip to content

Registered aircraft · 559

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-23-03-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:76-23-03-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:76-23-03-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:76-23-03-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:76-23-03-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:76-23-03-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.

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 N9517ESlail Fahmi Y · Beaverton, ORBuilt 1975 · S/N 75-30774 N9521ESchmidt Sanford V · Kingsville, MDBuilt 1976 · S/N 76-30832 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 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 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 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 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 N9673ELeedy Donald W · West Chester, OHBuilt 1976 · S/N 76-30823 N9678EKilo Row LLC · Rochester Hills, MIBuilt 1978 · S/N 78-30891 N9685ESwanson Michael J · Wayzata, MNS/N 77-32-167 N9709EViking Flying Association Inc · Scottsboro, ALBuilt 1977 · S/N 77-30855 N9718EHamilton Joe · Knowles, OKS/N 75-30796 N9719EJaeb Gerald E · Yankeetown, FLS/N 78-30865 N9720EBreneman William D · Alexandria, VABuilt 1976 · S/N 76-30842 N9723ENabarrette Angel · Odessa, TXS/N 76-30836 N9732ETucker Karlton · Washington, DCS/N 77-30852 N9739ERegistered aircraftBuilt 1978 · S/N 78-30896 N9745EThornburg Dawn M · Queen Creek, AZBuilt 1978 · S/N 78-30871 N9748EAnderson Aviation LLC · Fairfield, IABuilt 1976 · S/N 76-30835 N9764EWard David J · Flower Mound, TXBuilt 1978 · S/N 78-30876 N9774EDeichsel Frank J · Brea, CAS/N 77-30849 N9781EZielinski Alan D · Vlg Of Lakewd, ILBuilt 1976 · S/N 76-32-163

Back to AD 76-23-03 R1