Skip to content

Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N9270PPenn Landmark Corp · Pinehurst, NCS/N 24-4770 N9272PH&R Aircraft LLC · Kansas City, MOBuilt 1968 · S/N 24-4772 N92743Dulles Aviation Inc · Bristow, VABuilt 1997 · S/N 4496014 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 N927PTReds Asset Managers LLC · Pottsville, PABuilt 1976 · S/N 27-7754008 N927SUOhio State University · Columbus, OHBuilt 2021 · S/N 4496528 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 N9290PSpartan Education LLC · Tulsa, OKBuilt 1997 · S/N 4496019 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 N92BCRobert Craig LLC · Wilmington, DEBuilt 1995 · S/N 27-4823 N92BHHeydorff Stephen F Trustee · Sierra Madre, CABuilt 1969 · S/N 30-1852 N92DMD & M Flyers LLC · Petoskey, MIBuilt 1978 · S/N 27-7854107 N92EEGw Aero LLC · Arnold, MDBuilt 1959 · S/N 24-1668 N92NEAnderson Aviation LLC · Bulverde, TXBuilt 1964 · S/N 30-459 N93001Despain Ken O · Marysville, WABuilt 1952 · S/N 22-722 N9301DGrammer Brendan L · Canby, ORS/N 22-6312 N9303PDyster Justin C · Coeur D Alene, IDBuilt 1968 · S/N 24-4799 N9304DKenneson Robert P DBA · Eureka, KSS/N 22-6315 N9308PExecutive Enterprise Solutions LLC · Mount Pleasant, SCBuilt 1969 · S/N 24-4804 N930ERDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 2002 · S/N 4496154 N930LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496418 N930MDTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1967 · S/N 27-3787 N9311DRegistration Pending · Knoxville, TNRegistration pendingBuilt 1958 · S/N 22-6322 N9312DMcdonald Steve W · Lino Lakes, MNBuilt 1958 · S/N 22-6323 N9312PGregory John P · Riverside, CABuilt 1969 · S/N 24-4808 N9313PPencosky Edward A Jr · Manorville, NYBuilt 1969 · S/N 24-4809 N9314DCallahan Ashton G · Homer, AKBuilt 1958 · S/N 22-6325 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 N9319DCloud Buster LLC · Bloomfield, IABuilt 1958 · S/N 22-6332 N931LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496419 N9321DNiec Casmier M · Clio, MIFirst renewal noticeBuilt 1958 · S/N 22-6334 N9321PRegistered aircraftBuilt 1969 · S/N 24-4818 N9322DHitchcock Mark J · Scottsdale, AZBuilt 1958 · S/N 22-6335 N9324DRegistered aircraftBuilt 1958 · S/N 22-6337 N9325PCody William James · South Lyon, MIBuilt 1969 · S/N 24-4822 N9327PKrb LLC · Rupert, IDBuilt 1969 · S/N 24-4825 N9329PLenders Insurance Solutions Group LLC · Ozark, MOBuilt 1969 · S/N 24-4827

Back to AD 85-02-05 R1