Skip to content

Registered aircraft · 12,925

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-13-04') 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-13-04') 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-13-04')
    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-13-04')
  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-13-04')
  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-13-04')
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.

N10006Coutches Robert Hercules DBA · Livermore, CABuilt 1955 · S/N BG-72 N1000THaughton Douglas L · Gig Harbor, WABuilt 1957 · S/N D-4980 N1000YBarkhimer James C · Iraan, TXBuilt 1954 · S/N 30999 N1007THollar Larry · Winston Salem, NCBuilt 1973 · S/N 18262411 N1009PFerrier William T · Woodland, CABuilt 1958 · S/N 34994 N100CAFass Flyers LLC · Garden Ridge, TXBuilt 1978 · S/N 18266536 N100FPFlying Particles Inc · Livermore, CABuilt 1974 · S/N 18262957 N100KFAlbrecht Douglas D · Hobart, INBuilt 1966 · S/N 18257496 N100MMFarmer Aviation LLC · Milan, MIS/N 33611 N100SDDivan Jeremy E · Castle Rock, COBuilt 1960 · S/N 52853 N100SFSafe Flight Instrument LLC · White Plains, NYBuilt 1979 · S/N TC-2211 N100SLOlson Gordon N · Racine, WIBuilt 1971 · S/N 18260900 N1011SAfrican American Airlines Inc · Brandon, FLBuilt 1964 · S/N 310I0092 N10176Abm Flights LLC · Pawleys Island, SCBuilt 1969 · S/N 18260141 N101APatterson Mark T · Kodiak, AKBuilt 1959 · S/N 50486 N101GHSan Diego Community College District · San Diego, CAS/N 18260875 N101KTBryan Jerry E · Kathleen, GABuilt 1978 · S/N 18266264 N101RGTree Air LLC · Vero Beach, FLBuilt 1967 · S/N 18258526 N101SPHawkes Clark · Gillsville, GABuilt 1986 · S/N 18268562 N101TCTcm Flying Club Inc · Mobile, ALBuilt 1968 · S/N 18259330 N101WPScc Associates Ltd · Wilmington, DEBuilt 1975 · S/N 18264220 N1020MWinner Philip · Houston, TXBuilt 1975 · S/N 18264208 N1021CRiener Clinton G · Cottonwood, IDBuilt 1966 · S/N 18257409 N1022MHilton David L · Shreveport, LABuilt 1975 · S/N 18264209 N1024MEdwards Chris R · Meadow Vista, CABuilt 1975 · S/N 18264210 N1025MSupina Robert P · Richmond, TXBuilt 1975 · S/N 18264211 N1028MWenz Michael D · Gillette, WYBuilt 1975 · S/N 18264212 N102CDrain Alan K · Columbus, MTS/N 30501 N102PSHunt Jimmie · Leary, GABuilt 1953 · S/N G-76 N10319Battle Creek Aero Club Inc · Kalamazoo, MIBuilt 1957 · S/N BG-318 N10322Skyview Resources LLC · Holland, MIBuilt 1957 · S/N BG-322 N1037BSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1957 · S/N D-5311 N1037TJohnson Shem E · Bonners Ferry, IDBuilt 1972 · S/N 18260859 N1037VPulse Jeremy D · Moore, MTBuilt 1968 · S/N 18051989 N103PBBentley Jeffrey W · Kenmore, WABuilt 1957 · S/N 34372 N1041MHubbard Bennett L · Piedmont, ALBuilt 1975 · S/N 18264214 N10442Hilty David J · Kodiak, AKBuilt 1957 · S/N 22595 N10445Hartz Mark E · Stuttgart, ARBuilt 1953 · S/N 23397 N104BU1984k LLC · Gypsum, COS/N 18254352 N104HSErdmann Hollis K · Santa Monica, CABuilt 1973 · S/N 182-61758 N104NRMiller Dale D · Eagle River, AKBuilt 1966 · S/N 18051693 N104PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 182-63801 N104PMPats Offroad Inc · Mitchell, SDS/N 18258085 N104SPJanaitis Aviation LLC · Middletown, DEBuilt 1973 · S/N 18261667 N1050VState Of Wisconsin · Madison, WIBuilt 1968 · S/N 18051966 N1052MFendt Alan D Trustee · Dexter, MIBuilt 1975 · S/N 18264216 N10554T34sum LLC · Lake In The Hills, ILS/N CCF-34-37 N1055MRyan Michael W · Long Beach, CABuilt 1975 · S/N 18264217 N105SPDepartment Of Emergency Svcs & Public Protection · Hartford, CTBuilt 1984 · S/N 18268425 N105VBHughes Francis A · Ltl Egg Hbr Twp, NJBuilt 1981 · S/N 18268138

Back to AD 73-13-04