Skip to content

Registered aircraft · 54,015

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N7556VWennerstrom Kirk · Norwalk, CTBuilt 1976 · S/N 177RG0852 N75571Kohls Bruce P · Melbourne, KYBuilt 1976 · S/N 17267817 N75572Bean Keith Owen · Glenwood, IABuilt 1976 · S/N 17267818 N75575Mayo William J Jr · Reed Point, MTBuilt 1976 · S/N 17267820 N7557GLe Gros Donald P · Jennings, LABuilt 1970 · S/N 17259257 N7557MRegistration Pending · Warrensburg, MORegistration pendingBuilt 1959 · S/N 55857 N7557SBooher Travis J · Missoula, MTS/N 18265206 N7557TArizona Flyers Club Inc · Tucson, AZBuilt 1977 · S/N R18200038 N7557VTexas Dentco LLC · El Paso, TXBuilt 1976 · S/N 177RG0853 N7557XWright Aero Inc · Saint Cloud, MNBuilt 1977 · S/N R18200099 N75586Adventist World Aviation · Wilson, NCBuilt 1976 · S/N 17267829 N75587Ullah Muhammad K · Federalsburg, MDBuilt 1976 · S/N 17267830 N75588Emry Scott D · Brookings, ORBuilt 1976 · S/N 17267831 N7558GKessler Garry A · Lansing, WVS/N 17259258 N7558HAlaska Bear Safaris LLC · Homer, AKS/N 18503394 N7558LBahinting Dan Brian M · Rosamond, CABuilt 1978 · S/N A1520819 N7558MPrice David B · Gallipolis, OHBuilt 1959 · S/N 55858 N7558NRegistration Pending · Benton, ARRegistration pendingBuilt 1974 · S/N 18263247 N7558SUbarri Luis M · Caguas, PRBuilt 1976 · S/N 18265207 N7558VSisk James G · Coppell, TXBuilt 1976 · S/N 177RG0854 N75590Burgess Wayne R · Brown City, MIBuilt 1976 · S/N 17267832 N75591Reynolds Darryl G · Wills Point, TXBuilt 1977 · S/N 17267833 N75596Christian Charles R · La Crescenta, CABuilt 1976 · S/N 17267837 N75598Columbia Jet Center Inc · Columbia, MOBuilt 1976 · S/N 17267839 N7559GLopez Johnny · Henderson, NVBuilt 1970 · S/N 17259259 N7559KSkyway II LLC · Naples, FLS/N P21000410 N7559MPatton Steven W · Fayetteville, ARBuilt 1959 · S/N 55859 N7559SSand John · Albany, MNBuilt 1976 · S/N 18265208 N7559UFreeman Jet LLC · Cape Coral, FLBuilt 1975 · S/N 15077736 N7559VNorton Lyle K · Coquille, ORBuilt 1976 · S/N 177RG0855 N755CCStik LLC · Batesville, ARBuilt 1976 · S/N 18265201 N755CMCluster Fish LLC · Charleston, SCBuilt 1980 · S/N 21063934 N755HBBrown William Henry · Ravenna, TXBuilt 1979 · S/N 18053018 N755MCCisneros Joe M · Nashville, TNBuilt 1983 · S/N R18201959 N755PR101 Flight LLC · Waterford, MIBuilt 1976 · S/N 17267405 N755SWMelendez Daniel Alexan · Yuma, AZBuilt 1975 · S/N 21060965 N755TGInverted Aviation LLC · Atascadero, CABuilt 1977 · S/N 18265666 N755WUsda Forest Service Fepp · Malvern, ARBuilt 1958 · S/N 50252 N75600Airspeed Marketing LLC · Phoenix, AZFirst renewal noticeBuilt 1976 · S/N 17267840 N75601Sierra Corp · Worthngtn Spg, FLBuilt 1976 · S/N 17267841 N75602Jkg LLC · Murfreesboro, TNBuilt 1976 · S/N 17267842 N75603Riexinger Keith D · Ellensburg, WAFirst renewal noticeBuilt 1976 · S/N 17267843 N75605Miller Mark · Atascadero, CABuilt 1977 · S/N 17267845 N75608Albertson Michael D · Greenwood, SCBuilt 1976 · S/N 17267847 N7560DJiang Jun · Fremont, CABuilt 1979 · S/N 17272922 N7560GGreen Carl S · Crivitz, WIS/N 15074699 N7560HRio Brazos Aviation LLC · Waco, TXBuilt 1977 · S/N 18503396 N7560KAlbert Bryan Wayne · Palmer, AKBuilt 1976 · S/N 18052676 N7560MShenk Mike D · Harper, ORBuilt 1959 · S/N 55860 N7560SBeatty David · Hollister, CABuilt 1981 · S/N R18201712

Back to AD 87-20-03 R2