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.

N655PAWahleithner James K · Sacramento, CABuilt 1968 · S/N 32-40305 N6560WBeaunaux John-Daniel S · Graham, WABuilt 1964 · S/N 28-20641 N6561JKyode Inc · Creswell, ORS/N 28-5012 N6561WAnderson Vance K · Eugene, ORBuilt 1965 · S/N 28-20642 N6562JSmrekar Andrew E · Edgerton, WIBuilt 1968 · S/N 28-5013 N6562WRm & Lp Ltd · Azalea, ORS/N 28-20643 N6564JL K H LLC · Boyden, IABuilt 1968 · S/N 28-5016 N6568JMorring Roy S · New Hope, ALBuilt 1968 · S/N 28-5021 N6569JLegend Aviation LLC · Columbus, MSBuilt 1968 · S/N 28-5022 N6569WAdams Ronald B · Statesboro, GABuilt 1965 · S/N 28-20650 N656FTFlorida Institute Of Technology Inc · Melbourne, FLBuilt 2024 · S/N 28020173 N656NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881156 N6570JJenkins Robert Martin · Westminster, MDBuilt 1968 · S/N 28-5023 N6570WMurillo Raymond · Pico Rivera, CAS/N 28-20651 N6571JLima Alpha LLC · Pearcy, ARBuilt 1968 · S/N 28-5024 N6572JFletchall Jeremy S · Queen Creek, AZBuilt 1968 · S/N 28-5025 N6572WBoydstun Saylor Krystene · Brady, TXBuilt 1964 · S/N 28-20653 N6573JBeecher Bees Inc · Beecher, ILBuilt 1968 · S/N 28-5026 N6573WKing Isaac · Coahoma, TXBuilt 1965 · S/N 28-20654 N6575WStrouse Joshua L · Columbia, MOBuilt 1965 · S/N 28-20656 N6576JPa28 Nevada LLC · Incline Village, NVBuilt 1968 · S/N 28-5030 N6577JSpark Solar Power LLC · Chandler, AZBuilt 1968 · S/N 28-5032 N6577WAdventist World Aviation · Wilson, NCFirst renewal noticeBuilt 1965 · S/N 28-21273 N6578JMalone W Paul · Coulee City, WAS/N 28-5033 N6578WHanauer Keith A · Bloomfield, INBuilt 1965 · S/N 28-20659 N65794Baker Curtiss L · Kinston, NCBuilt 1967 · S/N 28-23302 N6579JBender Auto Body Inc · Middleville, MIBuilt 1968 · S/N 28-5034 N657CAOlson David A · New Underwood, SDBuilt 1966 · S/N 28-22371 N657NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881167 N6580JPoppy Wayne J · New London, WIBuilt 1968 · S/N 28-5036 N6580WPanero Philip J · Merritt Island, FLBuilt 1965 · S/N 28-20661 N6582URing Zachary B · Moreno Valley, CABuilt 1979 · S/N 28-7911190 N6583JPrestige Aircraft Inc · Swanton, VTBuilt 1968 · S/N 28-5040 N6584WCook Margaret · Newark, CABuilt 1965 · S/N 28-20665 N6588JDickerson Del A · Seffner, FLBuilt 1968 · S/N 28-5046 N6588WLedbetter Danny · Muscle Shoals, ALBuilt 1965 · S/N 28-20674 N6589JMertz Travis Lee · Danville, KYBuilt 1968 · S/N 28-5048 N658APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843770 N658CCYale Companies LLC DBA · Fishers, INBuilt 2025 · S/N 2881919 N658FLRowlett William R Jr · Russellville, ARBuilt 1971 · S/N 28-7125575 N658FTFlorida Institute Of Technology Inc · Melbourne, FLBuilt 2024 · S/N 28020183 N658LGAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881906 N658NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881163 N6590JRegistration Pending · Rathdrum, IDRegistration pendingBuilt 1968 · S/N 28-5049 N6592JWorland Flying Club LLC · Worland, WYBuilt 1968 · S/N 28-5052 N6592WChait Braeden Abraham · Vancouver, WAS/N 28-20681 N6593JRed Tail Scholarship Foundation · Tuskegee, ALBuilt 1968 · S/N 28-5053 N6594FTabbert William · Diamondhead, MSBuilt 1976 · S/N 32R-7780032 N6594JHub City Aviation Academy LLC · Lubbock, TXBuilt 1968 · S/N 28-5054 N6596WN6596w LLC · Derby, KSBuilt 1965 · S/N 28-20686

Back to AD 87-08-08 R3