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.

N38911Sams Aviation LLC · Decatur, ILBuilt 1977 · S/N 32R-7780488 N38912Congco Antoine Mark J · New Caney, TXBuilt 1977 · S/N 32R-7780489 N38914Acadian Aviation Pilot Training Centre Inc · Lafayette, LABuilt 1977 · S/N 28-7716291 N38919Sale Reported · Sarasota, FLSale reportedBuilt 1977 · S/N 28R-7737123 N3891FJjcw Aviation Inc · Athens, TXBuilt 1976 · S/N 32R-7680407 N3891TJones Rodney D · Corcoran, CABuilt 1967 · S/N 28R-30220 N3892KRowley Rodney N · Duchesne, UTS/N 28-23763 N38944Lewis David A · Fairfield, CAFirst renewal noticeBuilt 1977 · S/N 28R-7703284 N38945Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 32R-7780490 N3894FNorth Shore Aero Club · Beverly, MABuilt 1976 · S/N 28-7690459 N3894TBsa Leasing LLC · Pocatello, IDBuilt 1967 · S/N 28R-30223 N3894WElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1966 · S/N 32-840 N38952Ponto Phillip R · Vista, CABuilt 1977 · S/N 28-7716297 N38954Faulkner Wade DBA · Sterrett, ALBuilt 1977 · S/N 28-7716299 N3895FGreever Steven M · Spearman, TXBuilt 1977 · S/N 28R-7737002 N3895TPaetzold Carson · Jacksonville, FLBuilt 1967 · S/N 28R-30224 N38968Vagabond Flying Association · Winfield, ILBuilt 1977 · S/N 28-7716300 N38969Vandervelden Harmen J · Ware, MABuilt 1977 · S/N 28-7716301 N3896FEssary Larry R · Mc Neal, AZS/N 28R-7635376 N38970Triple R Aviation LLC · Cleburne, TXBuilt 1977 · S/N 28-7716302 N38972August Aero LLC · Kalispell, MTS/N 28-7716304 N38974International Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 28-7716305 N38981Kreck Blake T · Terrell, TXBuilt 1977 · S/N 28R-7703290 N38983N38983 LLC · Fort Worth, TXBuilt 1977 · S/N 32R-7780494 N38984Registered aircraftS/N 32R-7780495 N38986Ascend Aviation LLC · Bountiful, UTBuilt 1977 · S/N 28-7716306 N38987Ocean City Flying Club LLC · Middletown, RIBuilt 1977 · S/N 28-7716308 N38988Bms Aircraft LLC · Tinley Park, ILBuilt 1977 · S/N 28-7716309 N38989M5 LLC · Kit Carson, COBuilt 1977 · S/N 28-7716310 N38990Augusta Aviation Inc · Hilton Head Island, SCBuilt 1977 · S/N 28-7890002 N38991Jaquez Francisco P · Corona, NYBuilt 1977 · S/N 28R-7703291 N38995Baxter Donald J · Dallas, TXBuilt 1977 · S/N 28R-7703292 N38996Cherokee Kling LLC · Monroe, CTBuilt 1977 · S/N 32-7740104 N38997Blg Air Inc · State College, PABuilt 1977 · S/N 32R-7780496 N38999Raymond O Bentley Inc · Winter Haven, FLBuilt 1977 · S/N 32R-7780497 N3899TKaragiannis Nikitas · Fort Worth, TXBuilt 1967 · S/N 28R-30230 N3899WMauldin Brett · Madison, GABuilt 1966 · S/N 32-845 N389BWNewton Christian D · Custer, SDS/N 3246033 N389CACox Gary Brian · Tucson, AZS/N 2811025 N389GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881174 N38CTAerialcam Media LLC · Goliad, TXBuilt 1977 · S/N 28-7890025 N38DDHoke Timothy K · San Antonio, TXBuilt 1966 · S/N 28-10734 N38DSMiller Ronald L · Jackson, WYS/N 28R7931177 N38GHLagemann Jeffrey P · Cocoa, FLS/N 28-4264 N38JPLaymon Kenneth D · Redlands, CABuilt 1976 · S/N 28-7690396 N38LSLambert Larry W · Plain City, OHBuilt 1963 · S/N 28-1348 N38NBSailer Christopher J · Loveland, OHBuilt 1965 · S/N 28-2764 N38TXGlinn Andrew T · Keystone, NEBuilt 1977 · S/N 28R-7703297 N38WJFerguson Scott D · Valparaiso, INBuilt 1975 · S/N 28R-7535327 N38WMMariani Matthew J · Santa Rosa, CAFirst renewal noticeBuilt 1965 · S/N 28-2226

Back to AD 87-08-08 R3