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.

N9371ACosper Rodney S · Killeen, TXS/N 7450 N9371XAdventure Aircraft And Equipment LLC · Chelan, WABuilt 1962 · S/N 18253771 N9372GAcosta Gregory P · Mandeville, LABuilt 1971 · S/N 18260912 N9372XSleeping Giant Flying Club Inc · Helena, MTBuilt 1962 · S/N 18253772 N9373AAlis Russell D · Fairbanks, AKBuilt 1949 · S/N 7452 N9373TAf&S LLC · Anchorage, AKBuilt 1960 · S/N 50873 N9374GPreston Jonathan · Murrieta, CABuilt 1971 · S/N 18260914 N9374HBarr Air Patrol LLC · Mesquite, TXBuilt 1981 · S/N 18267939 N9375AGillam Donald E · Lafayette, LABuilt 1949 · S/N 7454 N9375XRubber Chicken Airlines LLC · Kalispell, MTS/N 18253775 N9376CNicholas Adam Ferraro · Benson, AZBuilt 1955 · S/N 31774 N9377AHawkins Bobby J · Greybull, WYBuilt 1949 · S/N 7456 N9378XWhitewater Aviation LLC · Lansing, WVBuilt 1985 · S/N 18268505 N9379CWestern Pilot Service Inc · Phoenix, AZBuilt 1955 · S/N 31777 N9379TTracer LLC · Arkadelphia, ARBuilt 1960 · S/N 50879 N9379XFoster Hartford L · Whitefield, MEBuilt 1962 · S/N 18253779 N9379YFitzgerald Aviation LLC · Bluffton, SCBuilt 1981 · S/N 21064491 N9380GSclafami Michael · New Waverly, TXBuilt 1971 · S/N 18260920 N9380XJacobi Gregory A · Alex, OKBuilt 1962 · S/N 18253780 N9381XLazy Eight Flying Club LLC · New Richmond, WIBuilt 1962 · S/N 18253781 N9382ASeniw Alan G · Bonfield, ILBuilt 1949 · S/N 7461 N9382HDhc Aviation LLC · Toccoa, GABuilt 1981 · S/N 18267941 N9382XBoyd David · West Creek, NJBuilt 1985 · S/N 18268506 N93836Clarkson Michael D · Anniston, ALBuilt 1974 · S/N 21060426 N9383CLewis Allen R · Anchorage, AKBuilt 1955 · S/N 31781 N9384CWright Kevin P · Anchorage, AKBuilt 1961 · S/N 18051030 N9385XPipkorn Alan J · Phillips, WIBuilt 1962 · S/N 18253785 N93867Sunup Flyers Coop · Moscow, IDBuilt 1974 · S/N 21060440 N9386AWarhank David · Rudyard, MTBuilt 1949 · S/N 7465 N9386CRizzo Marco L · San Luis Obispo, CABuilt 1955 · S/N 31784 N9386XMcgee David · West Monroe, LABuilt 1985 · S/N 18268508 N9387AMitchell Jeffrey S · Coldwater, OHBuilt 1949 · S/N 7466 N9387XKillam Rodney A · Carlinville, ILBuilt 1962 · S/N 18253787 N93887Dan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1974 · S/N 21060445 N9389AClark Christian Benjamin · Denver, COBuilt 1950 · S/N 7468 N9389CLawrence Blake C · Monument, ORBuilt 1955 · S/N 31787 N9389XBeckelic Michael E · Acworth, GABuilt 1962 · S/N 18253789 N938CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282403 N9391GBlair Stanton M · Kingman, AZBuilt 1971 · S/N 18260931 N9391XGravenstede Nelson F · Newton, NJBuilt 1962 · S/N 18253791 N9393CStover Shawn · Placerville, CAS/N 31791 N9393HC&C Specialty Inc · Wilmington, DES/N 18267942 N9393XCalvin Glenn · Prescott, AZBuilt 1985 · S/N 18268510 N9394CRhr Management Inc · Bancroft, WIBuilt 1955 · S/N 31792 N9394XBlue Sky Flyers Inc · Punta Gorda, FLBuilt 1962 · S/N 18253794 N9395ARothacker Aviation LLC · Chester Springs, PABuilt 1950 · S/N 7474 N9395XCoyote Air · Austin, TXBuilt 1985 · S/N 18268511 N9396XGonzalez Leopoldo · Laredo, TXBuilt 1985 · S/N 18268512 N93974Just Plane Stupid LLC · Loveland, COBuilt 1974 · S/N 21060469 N9397ABarron Aviation LLC · Perry, MOBuilt 1950 · S/N 7555

Back to AD 84-10-01 R1