Skip to content

Registered aircraft · 22,413

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N36067Armor Corps Inc · Spring Hill, TNBuilt 1978 · S/N 28R-7803309 N3606MStuart B Stephens Dds Ms Plc · Yukon, OKBuilt 1978 · S/N 28-7890277 N36071Aero Systems Consultants Inc · Tulsa, OKBuilt 1978 · S/N 32R-7885155 N36073M C Aviation Holding Co LLC · Bryan, TXBuilt 1978 · S/N 32R-7887021 N36077Coffey Diane L · Chuckey, TNBuilt 1978 · S/N 28-7890492 N3607WOceanstate Flying Club Inc · Little Compton, RIBuilt 1966 · S/N 32-506 N3608MRoman Peter A · Aurora, ILBuilt 1978 · S/N 28-7816359 N3608WHand Andy A · Waco, TXBuilt 1966 · S/N 32-507 N36094Jupiter Flight Service And Investing LLC · Lithonia, GABuilt 1978 · S/N 28-7816612 N36095Wiese Robert M · Washburn, NDBuilt 1978 · S/N 28-7890494 N36096Miami Arrow LLC · Peru, INBuilt 1978 · S/N 28R-7837265 N36097Conner Don R · Hot Springs, SDFirst renewal noticeS/N 28R-7803310 N3609MKosbruk Patrick E · Perryville, AKBuilt 1978 · S/N 28-7816360 N3609QNorthern Aviation LLC · Palmer, AKBuilt 1977 · S/N 32R-7780319 N3609WConverse James Robert · Port Saint Lucie, FLBuilt 1966 · S/N 32-509 N360BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2025 · S/N 2881913 N360FAStratus Rr LLC · New Castle, DEBuilt 2022 · S/N 28020060 N360SBYoung Dennis L · Fort Worth, TXBuilt 1978 · S/N 32R-7885159 N36115Turner Randall D · Tolar, TXBuilt 1978 · S/N 28-7816613 N36116Meriden Aviation Center LLC · Meriden, CTBuilt 1978 · S/N 28-7816614 N36118Cg Aviation LLC · Woods Cross, UTFirst renewal noticeBuilt 1978 · S/N 28-7890495 N36120United States Air Force Owner · Hanscom Afb, MABuilt 1978 · S/N 28R-7837266 N36129Tjarks Heyo H · Dubuque, IABuilt 1978 · S/N 32R-7885164 N3612QFerrara Anthony · Warren, NJS/N 32R-7780320 N3612WKard Aviation LLC · Greenville, SCBuilt 1966 · S/N 32-513 N36134Manning John W · Floyds Knobs, INBuilt 1978 · S/N 28-7816615 N3613WTurner Travis · Chetek, WIS/N 32-514 N36149Gilbert Paul · Diamondhead, MSBuilt 1978 · S/N 32R-7885165 N3614RKrautschun Bart · Spearfish, SDS/N 28-5710 N36150Bas Part Sales LLC · Greeley, COBuilt 1978 · S/N 32R-7885166 N3615RMorrissey William T Trustee · Friday Harbor, WAS/N 28-5711 N36167James Brett · Louisburg, NCBuilt 1978 · S/N 28-7890497 N36185Stapleton Rita · Gallipolis, OHBuilt 1978 · S/N 32R-7885169 N36187Swaz Aviation LLC · Mesa, AZBuilt 1978 · S/N 28-7816619 N3618MRatcliffe Andrew M · Jerome, AZBuilt 1978 · S/N 28-7890319 N36194Cripps Alan Stephen · Hoover, ALBuilt 1978 · S/N 32R-7885171 N3619KKirk Trevor A · Ponderay, IDBuilt 1967 · S/N 28-23656 N3619RBachelor Cabin Flying Services Inc · Kokomo, INBuilt 1969 · S/N 28-5714 N361MEN361me LLC · Blanding, UTBuilt 1978 · S/N 28-7890361 N361MKNorth Star Aviation Inc · Mankato, MNBuilt 2022 · S/N 2881588 N361NDUniversity Of North Dakota · Grand Forks, NDBuilt 2024 · S/N 2881827 N361RPRocha Aviation LLC · Prescott Valley, AZBuilt 1973 · S/N 32-7440046 N361WA32 Poco LLC · Dover, DEBuilt 1999 · S/N 3257121 N361WEOn Da Way Exotic Car Rentals LLC · Fort Lauderdale, FLS/N 28-23827 N361ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881644 N362Andi 362 LLC · Duncan, SCBuilt 1975 · S/N 28-7690096 N36201Bmw Lance Inc · Gardner, MABuilt 1978 · S/N 32R-7887027 N36202Red Rock Aircraft Leasing LLC · Hurricane, UTBuilt 1978 · S/N 32R-7887028 N36209Indian Hills Community College · Ottumwa, IABuilt 1978 · S/N 28-7816622 N3620RBarker Richard · Temecula, CABuilt 1970 · S/N 28-5716

Back to AD 87-08-08 R3