Skip to content

Registered aircraft · 22,411

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.

N2024RStorm David A · Lowell, ARBuilt 1969 · S/N 28-5432 N2028RMurphy Kevin Adam · Douglas, GABuilt 1969 · S/N 28-5437 N202ASQualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 287305465 N202CBBrothers Aviation Va LLC · Manassas, VABuilt 1973 · S/N 28-7305360 N202MAHatchett William Hal · Edisto Island, SCBuilt 1970 · S/N 28-26740 N202WFPro Express LLC · Alliance, NEBuilt 1978 · S/N 28R7803325 N2032MKab Air LLC · Eden Prairie, MNBuilt 1978 · S/N 32-7840077 N2034RPn4 Aviation Holdings LLC · Bishop, CABuilt 1969 · S/N 28-5439 N20352035 Holdings LLC · North Las Vegas, NVBuilt 2007 · S/N 3257462 N2035ULihs Ashley · Yankton, SDBuilt 1974 · S/N 28-7415467 N203BWAlexander Katherine · Fishers, INBuilt 1976 · S/N 28R-7635113 N203CCMonarch Air LLC · Dewitt, MIBuilt 1979 · S/N 28-7911110 N203DAerotres LLC · Lakeville, MNBuilt 2020 · S/N 2881425 N203EAEtheredge Mark · Pell City, ALBuilt 2023 · S/N 28020118 N203FSpace Coast Aircraft Co · Merritt Island, FLBuilt 1984 · S/N 288416083 N203MABuckau Michael S · Costa Mesa, CABuilt 1970 · S/N 28-26738 N203MDSinsaja Holdings LLC · Sheridan, WYBuilt 1976 · S/N 28-7625251 N203SJCorrado Christopher · Newton, NJS/N 32-40037 N2041RBlair Darrell E · Trinity, NCBuilt 1969 · S/N 28-5440 N2043MPaxton Flyers · Loda, ILBuilt 1977 · S/N 28-7816241 N2043RBoltjes Thomas S · Platte, SDBuilt 1969 · S/N 28-5441 N2044MDowling Michael L · Adrian, MIBuilt 1977 · S/N 28-7816242 N2046RBiser Group LLC · Huntington, WVBuilt 1969 · S/N 28-5443 N2048MMiller Gerald L · Selinsgrove, PABuilt 1977 · S/N 28-7816244 N2049RHook Sean · Garden Ridge, TXBuilt 1969 · S/N 28-5445 N204EAEtheredge Mark · Pell City, ALBuilt 2023 · S/N 28020119 N204NDAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2002 · S/N 2844070 N204PCHestertown Aviation LLC · Monroe, GABuilt 1973 · S/N 32-7440036 N204RBRoper Benjamin F · College Station, TXS/N 28R-7703149 N204RKHermann Ron A · Sarasota, FLBuilt 1985 · S/N 28-8611003 N204SJStuart M Davis Inc · Rice, WABuilt 1972 · S/N 32-7240097 N2052MDehnel Kris P · Cedar Park, TXS/N 28-7890222 N2052RDybvig Abraham M · Bothell, WABuilt 1969 · S/N 28-5444 N2054MMcdonald Patrick R · Waverly Township, PABuilt 1977 · S/N 28-7890223 N2055MHarding Lawrence · Santa Monica, CABuilt 1977 · S/N 28R-7837063 N2056MSteele Shelly Sam · Spicewood, TXBuilt 1977 · S/N 28R-7803102 N2057MSeintec Corp · Aventura, FLBuilt 1977 · S/N 28R-7803103 N205FAStratus Rr LLC · New Castle, DEBuilt 2025 · S/N 28020205 N205SF242 Skies LLC · Troutman, NCBuilt 1977 · S/N 32R-7780311 N205SGWilliams Christopher · Wallingford, KYBuilt 2005 · S/N 3255041 N205THAaces Flight Operations LLC · Ellisville, MOBuilt 1981 · S/N 28-8190282 N205ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881606 N205ZDBibb James M · Citrus Heights, CABuilt 1979 · S/N 28-7921084 N2062MJadma LLC · Helena, MTBuilt 1977 · S/N 32R-7880051 N2062RMiller Mark T · Sugarcreek, OHBuilt 1969 · S/N 28-5447 N2064TClarke Bruce B · Port Angeles, WABuilt 1970 · S/N 28R-7135001 N2069MSeton Perry · Casper, WYBuilt 1977 · S/N 28-7816247 N206CBLewis Jeffrey R · Parker, COBuilt 1974 · S/N 28-7425230 N2070MD&L Aviations LLC · Breckenridge, TXBuilt 1977 · S/N 28-7890226 N2071MBudd Aircraft Enterprises Inc · Chesterfield, MOBuilt 1977 · S/N 28R-7837064

Back to AD 87-08-08 R3