Skip to content

Registered aircraft · 22,430

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.

N181YTailwinds Aviation Academy LLC · Grass Valley, CAS/N 28-8590089 N1820H5c1 Jet Center LLC · Boerne, TXS/N 28-7716053 N1820TCallender Richard · Presque Isle, WIBuilt 1971 · S/N 28R-7135122 N1821JWebber Alvin G · Bella Vista, ARS/N 28-24252 N1822HAdvanced Aviation Group LLC · Frederick, MDBuilt 1977 · S/N 28-7790345 N1822JWright Debra A · Avondale, PABuilt 1968 · S/N 28-24253 N1823JFroman Michael J · Mayer, MNBuilt 1968 · S/N 28-24254 N1823TShowalter Joshua J · Dougherty, IABuilt 1971 · S/N 28-7125206 N1824HAthar Glenola LLC · Mars, PABuilt 1977 · S/N 28-7790346 N1826JPope County Aviation LLC · Russellville, ARBuilt 1968 · S/N 28-24257 N1826TBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 28-7105105 N1827TSilverton Financial LLC · Wilmington, DES/N 28-7105106 N1828JLennon Arthella M · Dayton, OHS/N 28-24260 N1830JCarswell Ethan · Gray, GABuilt 1968 · S/N 28-24263 N18311Begay & Away LLC · Houston, TXS/N 32-40092 N1831TStachiw Mark A · Parker, TXBuilt 1971 · S/N 28-7105108 N1832TSymeonidis Andreas Alexandros · Scarsdale, NYBuilt 1971 · S/N 28-7105109 N1833JEsparza Phillip Gregory · Crowley, TXBuilt 1968 · S/N 28-24267 N1833TN1833t LLC · Wappingers Falls, NYBuilt 1971 · S/N 28-7105110 N1834JBurke Kevin A Trustee · Weare, NHBuilt 1968 · S/N 28-24268 N1834TCoffey County Airport · Burlington, KSBuilt 1971 · S/N 28-7105111 N1835TBlue Yonder LLC · Cottondale, ALBuilt 1971 · S/N 28-7105112 N1836JWright James J · Edwards, MOBuilt 1968 · S/N 28-24270 N1837JTolley Derek Evan · Mckinleyville, CABuilt 1968 · S/N 28-24272 N1837TKettrey Keith · Waxahachie, TXBuilt 1971 · S/N 28-7105113 N1838TN1838t LLC · Ballwin, MOBuilt 1971 · S/N 28-7105114 N1839TBluewater Airmotive Corp · Wilmington, DEBuilt 1971 · S/N 28-7125262 N183CFCherokee Flyers Inc · Vero Beach, FLBuilt 1999 · S/N 2843232 N1842JAgthe Thilo Claus · Highlands, NJBuilt 1968 · S/N 28-24277 N1842TPowell Gary · South Jordan, UTBuilt 1971 · S/N 28-7125273 N1843JMerlina Michael · North Reading, MABuilt 1968 · S/N 28-24278 N1843TWalko Timothy A · Florence, MAS/N 28-7105117 N1844JSwanberg Brian M · Federal Way, WABuilt 1968 · S/N 28-24279 N1846TSatern Tate P · Dakota City, IABuilt 1971 · S/N 28-7105119 N1847JMehrle Properties LLC · Mcclure, ILBuilt 1968 · S/N 28-24283 N1847TMayer Joseph J · Rolling Meadows, ILBuilt 1971 · S/N 28-7105120 N1848JFrozen Aero Enteprises LLC · Grand Forks, NDBuilt 1968 · S/N 28-24284 N184BWDevuono Derin D · Pocono Lake, PABuilt 1979 · S/N 28-7916345 N184CFPiper Aircraft Inc · Vero Beach, FLBuilt 1999 · S/N 2843242 N184JDRegistered aircraftBuilt 1977 · S/N 28-7790567 N184LGAb Prop Plane I LLC · Metairie, LAS/N 2881908 N184TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020240 N1851HKoelsch Benjamin · Nome, AKS/N 28-7725163 N1851JSande 6 Aviation Inc · Wilmington, DEBuilt 1968 · S/N 28-24288 N1852JHanneman Robert · Denver City, TXS/N 28-24289 N1853JSargent David W · Port Angeles, WABuilt 1968 · S/N 28-24290 N1854JM & D Aviation 2019 LLC · Ocklawaha, FLBuilt 1968 · S/N 28-24292 N1855JNicholson John · Sapulpa, OKS/N 28-24293 N1856JWood Dragon LLC · Portland, MEFirst renewal noticeBuilt 1968 · S/N 28-24294 N1857JMulas Joseph Anthony · Chesterfield, VABuilt 1968 · S/N 28-24295

Back to AD 87-08-08 R3