Skip to content

Registered aircraft · 6,916

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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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.

N9272PH&R Aircraft LLC · Kansas City, MOBuilt 1968 · S/N 24-4772 N9274NOkuda Hideki · Rncho Pls Vrd, CABuilt 1996 · S/N 2844008 N9274PMurray John F · Crystal Lake, ILBuilt 1968 · S/N 24-4774 N9276PHansen Stephen J · Redmond, WAS/N 24-4776 N9279PArdis Mitchell Farm LLC · Winnsboro, TXBuilt 1968 · S/N 24-4780 N927KRCandace A Larned Enterprises Inc · Long Beach, CABuilt 1973 · S/N 28R-7335156 N9282PCampbell Paul · Glade Spring, VABuilt 1968 · S/N 24-4782 N9284PDickinson Malcolm · Stamford, CTBuilt 1968 · S/N 24-4784 N9285PStumpf Bernard L · Westerly, RIBuilt 1968 · S/N 24-4785 N9288PLivingston Jerry D · Wichita, KSBuilt 1968 · S/N 24-4788 N9289PSvetlik Ludvik Julius · Victoria, TXS/N 24-4789 N928LYLp Aviation Maintenance LLC · Bayonne, NJS/N 28R-30007 N928SHPeros Dino · Pipersville, PABuilt 1975 · S/N 34-7670019 N928XAvant Homes LLC · Atlanta, GABuilt 1974 · S/N 347570066 N9290CMym Air LLC · Pattison, TXBuilt 1978 · S/N 28R-7837184 N9290KArrow Leaseback LLC · Danbury, CTBuilt 1976 · S/N 28R-7635231 N9292PRegistered aircraftBuilt 1968 · S/N 24-4791 N9293PCenterline Holdings Inc · Camden, DEBuilt 1968 · S/N 24-4792 N9294PJensen Thomas · Durango, COBuilt 1968 · S/N 24-4793 N9296PStevens John W · Westlake Village, CABuilt 1968 · S/N 24-4795 N9297P9797p LLC · San Angelo, TXBuilt 1968 · S/N 24-4796 N92BHHeydorff Stephen F Trustee · Sierra Madre, CABuilt 1969 · S/N 30-1852 N92DADelory Dana E · Shoreacres, TXBuilt 1992 · S/N 28-37057 N92ECStevens Faustin R · Kennewick, WABuilt 1977 · S/N 32R-7880007 N92EEGw Aero LLC · Arnold, MDBuilt 1959 · S/N 24-1668 N92GMPeri Joseph · Thorntown, INBuilt 1978 · S/N 28R-7803263 N92NEAnderson Aviation LLC · Bulverde, TXBuilt 1964 · S/N 30-459 N92UATaylor Aviation Inc · Montgomery, NYBuilt 1992 · S/N 2837058 N9301NAnderson Robert · Tonopah, AZBuilt 1969 · S/N 28R-35001 N9302FBlue High Horizons LLC · Clayton, GAS/N 32R-7780123 N9303PDyster Justin C · Coeur D Alene, IDBuilt 1968 · S/N 24-4799 N9308PExecutive Enterprise Solutions LLC · Mount Pleasant, SCBuilt 1969 · S/N 24-4804 N930RJN147sb LLC · Cortland, NYBuilt 1970 · S/N 28R-35754 N9310NApproach Partners LLC · Franklinton, NCBuilt 1969 · S/N 28R-35010 N9311NAmendt Joseph J III · Plymouth, MNBuilt 1969 · S/N 28R-35011 N9312PGregory John P · Riverside, CABuilt 1969 · S/N 24-4808 N9313PPencosky Edward A Jr · Manorville, NYBuilt 1969 · S/N 24-4809 N9315NDiir County Flying Inc · Sturgeon Bay, WIS/N 28R-35015 N9315PGrady Michael J · Farmington, NMBuilt 1969 · S/N 24-4811 N9316PProvost Stephen Nicholas · Saint Louis, MOBuilt 1969 · S/N 24-4812 N9317PFutter John H · Whately, MABuilt 1969 · S/N 24-4813 N9318PPorter Wayne · Phoenix, AZBuilt 1969 · S/N 24-4814 N9320NEagle Aviation Inc · Tucson, AZBuilt 1969 · S/N 28R-35020 N9321CBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 28R-7837191 N9321NRegistration Pending · Shreveport, LARegistration pendingBuilt 1969 · S/N 28R-35021 N9321PRegistered aircraftBuilt 1969 · S/N 24-4818 N9323CHangar 9 Inc · Aberdeen, SDBuilt 1978 · S/N 28R7803252 N9325PCody William James · South Lyon, MIBuilt 1969 · S/N 24-4822 N9327PKrb LLC · Rupert, IDBuilt 1969 · S/N 24-4825 N9328KSantoro Alexandre Jose · Mountain View, CABuilt 1976 · S/N 28R-7635232

Back to AD 97-01-01 R1