Skip to content

Registered aircraft · 20,481

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:84-10-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:84-10-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:84-10-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:84-10-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:84-10-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:84-10-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.

N732YCGiudici Carl E · Henderson, NVBuilt 1977 · S/N 21061872 N732YDPrivate Air LLC · Santa Rosa, CABuilt 1977 · S/N 21061873 N732YKDaly Arthur P · El Paso, TXFirst renewal noticeBuilt 1977 · S/N 21061879 N732YPCoppage Farm Services Inc · Braggadocio, MOBuilt 1977 · S/N 21061883 N732YZNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 1979 · S/N U20604741 N732ZANorthstar Center Properties · Los Angeles, CABuilt 1977 · S/N 21061894 N732ZBMuddy Wolf Holdings LLC · Wilmington, DEBuilt 1977 · S/N 21061895 N732ZCHoffman Dean Jr · Santa Ana, CABuilt 1977 · S/N 21061896 N732ZGStraight And Level LLC · Solana Beach, CABuilt 1977 · S/N 21061900 N732ZMTurbo 210 Air LLC · Galveston, TXBuilt 1977 · S/N 21061905 N732ZUMap Enterprises Inc · Mayfield, KYBuilt 1977 · S/N 21061912 N732ZVOppenheim Daniel A · Mandeville, LABuilt 1977 · S/N 21061913 N732ZZDakota Aerial Ministries · Fargo, NDS/N 21061917 N7330SNew Heights Aviation LLC · Decatur, TXBuilt 1976 · S/N 18265121 N7331NLost Creek Aviation LLC · Elkhorn, WIBuilt 1974 · S/N 18263115 N7331QKelly Timothy K · Dassel, MNBuilt 1972 · S/N 18260971 N7331SAzizi Habib E · Franklin, TNBuilt 1976 · S/N 18265122 N7331UBristol Bay Air Service Inc · Dillingham, AKBuilt 1977 · S/N 20700402 N7332SSmith Enterprises Inc · Grangeville, IDBuilt 1976 · S/N 18265123 N7333QMac Neill Malcolm G · Lake Junaluska, NCBuilt 1972 · S/N 18260973 N7333XFrederick Aero Development Inc · Murrieta, CABuilt 1977 · S/N R18200080 N7333YMayotte Stephen A · North Chelmsford, MABuilt 1977 · S/N R18200116 N7334NRobles James J · Oro Valley, AZBuilt 1976 · S/N U20603616 N7334QHurri-Clean LLC · Brewton, ALBuilt 1972 · S/N 18260974 N7334SKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1976 · S/N 18265125 N7335NEnrique Elias Luis · Chandler, AZS/N 21063221 N7335QStaas Justin W · Sacramento, CABuilt 1972 · S/N 18260975 N7335TNever Repress Laughter LLC · Villa Rica, GABuilt 1977 · S/N R18200029 N7336CDelta Kilo Av8 LLC · Bonita Springs, FLS/N 21063938 N7336NRoberts Frederick · El Segundo, CABuilt 1974 · S/N 18263120 N7336SAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1976 · S/N 18265127 N7337NSpitfire Aviation Inc · Wilmington, DEBuilt 1974 · S/N 18263121 N7337QCopper Ridge Express LLC · Iowa Falls, IABuilt 1978 · S/N R18200271 N7338QBotts Eugene J · Rosenberg, TXBuilt 1972 · S/N 18260978 N7338SFielding Kenneth G · Missoula, MTBuilt 1976 · S/N 18265129 N733EHSherwood Aviation Consultants Inc · Redondo Beach, CABuilt 1978 · S/N U20604761 N733KDLake Clark Holdings LLC · Port Alsworth, AKBuilt 1978 · S/N U20604772 N73408Shade Eric L · Dillingham, AKBuilt 1979 · S/N 20700586 N7340EStoberski John J · Henderson, NVBuilt 1959 · S/N 57040 N7340SDiamond K Rentals LLC · Tucson, AZS/N 18265131 N7340UYr-Aircraft Leasing LLC · Bethel, AKBuilt 1977 · S/N 20700407 N7340YStark Stephen · Fort Lauderdale, FLBuilt 1977 · S/N R18200118 N7341CT Cole Holdings I LLC · Paint Rock, TXBuilt 1980 · S/N 21063939 N7341QHahn John C · Sherwood, ARS/N 18260981 N7341XRth Enterprise Inc · Wilmington, DES/N R18200081 N7341YPond Alex P · Novi, MIBuilt 1977 · S/N R18200119 N7342QThistlesoar LLC · Plaquemine, LABuilt 1972 · S/N 18260982 N7343ELemanski Joseph S · Grosse Ile, MIBuilt 1959 · S/N 57043 N7344YJeffrey P Mcauley Dmd Inc · Midland City, ALBuilt 1977 · S/N R18200120 N7345QLester Darrell S · Riverton, UTBuilt 1972 · S/N 18260985

Back to AD 84-10-01 R1