Skip to content

Registered aircraft · 22,416

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.

N8819WBowen Donald M · Wasco, ORBuilt 1964 · S/N 28-10367 N881DTCleary Brothers LLC · Tompkinsville, KYBuilt 1997 · S/N 3257007 N881KBAero Quest LLC · Olive Branch, MSBuilt 2023 · S/N 28020115 N881PUTrustees Of Purdue University · West Lafayette, INBuilt 2025 · S/N 2881965 N881RJAnnalith LLC · Englewood, FLFirst renewal noticeBuilt 2005 · S/N 3232049 N881TAMcgough Julie E · Red Oak, TXBuilt 1966 · S/N 28-3023 N881WXBaron Services Inc · Huntsville, ALS/N 32R-7880042 N8820EDishman John David · Brooklyn, NYBuilt 1976 · S/N 28-7625161 N8820JSurles Willian T · Chuckey, TNBuilt 1965 · S/N 28-2774 N8821ERegistration Pending · Dothan, ALRegistration pendingS/N 28-7615166 N8821JJanssen Brittney Juen · Pleasantville, IABuilt 1965 · S/N 28-2775 N8822NFirestine Joseph W · Atwater, CABuilt 1969 · S/N 28-25670 N8823CMcgee David · West Monroe, LABuilt 1976 · S/N 28-7615130 N8823JBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 28-2778 N8823NAvia Flight Academy · Stratford, CTBuilt 1969 · S/N 28-25671 N8823WSpaulding Anthony Russell · Sonoma, CABuilt 1966 · S/N 28-10804 N8824CRodriguez Carlos S · Poughkeepsie, NYBuilt 1976 · S/N 28-7690167 N8824ECornelius John A · Fort Worth, TXBuilt 1976 · S/N 28R-7635216 N8824JJohnson Lawrence F · Ancorage, AKBuilt 1965 · S/N 28-2779 N8824NDale Keith Wayne · Gurdon, ARBuilt 1969 · S/N 28-25672 N8825JAlexander Carol E · Pineville, LABuilt 1965 · S/N 28-2780 N8825NMissouri River Flying Club LLC · Mandan, NDBuilt 1969 · S/N 28-25673 N8825WSires Mark Steven · Lake City, FLBuilt 1964 · S/N 28-10372 N8826NWg Aviation LLC · Shippenville, PABuilt 1969 · S/N 28-25675 N8828CHogan Dennis E · South Hadley, MABuilt 1976 · S/N 28R-7635183 N8829WDernbach Richard M · Glenbrook, NVBuilt 1964 · S/N 28-10374 N882TMLance Air LLC · Madison, WIBuilt 1977 · S/N 32R-7780273 N8830JAnderas Per R · Green Bay, WIBuilt 1965 · S/N 28-2927 N8831NAllen Aviation LLC · Mansfield, MABuilt 1969 · S/N 28-25682 N8831WForbes Aviation LLC · Boise, IDBuilt 1964 · S/N 28-10378 N8832JN597w Llp · Arnold, MDBuilt 1965 · S/N 28-2788 N8835NRegistered aircraftS/N 28-25685 N8835WPashkov Maxim · Los Angeles, CABuilt 1964 · S/N 28-10383 N8836JSonic Skunk Works LLC · Houston, TXBuilt 1965 · S/N 28-2793 N8837JJerry Wachtel N · Carleton, NEBuilt 1965 · S/N 28-2794 N8837NAlpha Kilo Aviation LLC · Wasilla, AKBuilt 1969 · S/N 28-25688 N8838JSchlensig Randall D · Anthem, AZBuilt 1965 · S/N 28-2795 N8838WSmith James A · Lyle, WAS/N 28-10387 N8839JPadgett John E · Austin, TXS/N 28-2796 N8839NCooper Thomas J · Henderson, NVBuilt 1969 · S/N 28-25690 N8839WKarval Fliers LLC · Karval, COBuilt 1964 · S/N 28-10388 N883ACPlane Fun Inc Tr Trustee · Snellville, GABuilt 1975 · S/N 28R-7535156 N883CFolkers Daniel E · Norwalk, IABuilt 1973 · S/N 28-7325345 N883MMoffett James D · North East, MDBuilt 1969 · S/N 28-26047 N8840NBouillon Gloria J · Somerville, MABuilt 1969 · S/N 28-25691 N8840WLee Ronald A · Bend, ORBuilt 1964 · S/N 28-10389 N8841JE & G Flying Club LLC · Alliance, OHBuilt 1965 · S/N 28-2798 N8841WRegistration Pending · Dilley, TXRegistration pendingBuilt 1964 · S/N 28-10390 N8842JCrowe Steven A · Bend, ORBuilt 1965 · S/N 28-2799 N8842SMcdowell Karen · Dunedin, FLS/N 2837032

Back to AD 87-08-08 R3