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.

N7291FTusing Richard C · Newell, SDBuilt 1968 · S/N 28-25205 N7291JCenterline Equipment Corp · Waukegan, ILBuilt 1968 · S/N 28-24643 N7291WKiser Eugene A · Sheboygan, WIBuilt 1963 · S/N 28-1357 N7292FAalderks Roger H · Blomkest, MNBuilt 1968 · S/N 28-25207 N7292JCapital Region Aviation Partners Inc · Troy, NYBuilt 1968 · S/N 28-24645 N7293JFuller Jaime E · Walnut Cove, NCBuilt 1968 · S/N 28-24647 N7294JForsyth Matthew J · Fayetteville, GABuilt 1968 · S/N 28-24649 N7294WCapstone Aviation LLC · Lancaster, CABuilt 1963 · S/N 28-1139 N7295JHaass Susan D Teese · Cypress, TXBuilt 1968 · S/N 28-24650 N7297JPearce Jim R · Stratford, TXBuilt 1968 · S/N 28-24652 N7297WTurner Joseph N · Chuckey, TNBuilt 1963 · S/N 28-1150 N7298FAgostini Joseph L · Broomall, PABuilt 1969 · S/N 28-25212 N7298JNapper Kenneth L · Sacramento, CABuilt 1968 · S/N 28-24653 N7298WSchnitiker Allan A · Pratt, KSS/N 28-1151 N7299FGardner Todd D · Poland, INS/N 28-25206 N7299WBugner David J · Savannah, GABuilt 1963 · S/N 28-1121 N729DRowe Perry D · Mccall, IDS/N 28-2930 N729FLFlight Adventures Llp · Pleasant Grove, UTBuilt 1972 · S/N 28-7225488 N729NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881024 N729RGMad Dog Services LLC · Vero Beach, FLS/N 32-7940021 N72CDG Brinkman Aviation Inc · Naperville, ILBuilt 1971 · S/N 28-7205013 N72DMPacific Flight Aviation LLC · Costa Mesa, CAS/N 2843471 N72KGrace Jesse L · Troutdale, ORBuilt 1967 · S/N 28-10927 N72MHQuasar Aircraft Corp · Jacksonville, FLBuilt 1978 · S/N 28R-7918008 N72NEr Flight LLC · Reedsville, PABuilt 1971 · S/N 28-7205125 N72RJEngerer Dennis E · Northville, MIBuilt 1968 · S/N 28R-30891 N72SDYooper Aviation LLC · Menominee, MIBuilt 1972 · S/N 32-7240099 N72SJCoghlan Douglas G · Salem, SCS/N 28R-7931092 N72WGJaja Properties LLC · Laurinburg, NCS/N 28-7310033 N7300WTaylor Robert P · Bothell, WABuilt 1963 · S/N 28-1064 N7301FMcpherson Alan · Big Bend Ntl Park, TXBuilt 1968 · S/N 28-25213 N7301JJach Joshua Spenser · Grand Prairie, TXBuilt 1968 · S/N 28-24596 N7303FAyrey Elias · Bellingham, WABuilt 1968 · S/N 28-25215 N7303JButtleman Robert L · Traverse City, MIBuilt 1968 · S/N 28-24588 N7304FReid Brian S · Merced, CAS/N 28-25216 N7304JAdk Flying Club Inc · Ballston Spa, NYBuilt 1968 · S/N 28-24648 N7305JMallozzi Anthony M · Norwalk, CTBuilt 1968 · S/N 28-24636 N7306FMeans James · Burleson, TXS/N 28-25219 N7307FEllis Johnathan · Evansville, WYS/N 28-25220 N7307JAlmonte Duran Arquimedes · Paterson, NJBuilt 1968 · S/N 28-24640 N7308CChandler Air Service Inc · Chandler, AZBuilt 1975 · S/N 28-7625075 N7308JMacdermaid Harry R · Kenai, AKFirst renewal noticeBuilt 1968 · S/N 28-24616 N7309CKeefer Ralph E · Markle, INBuilt 1975 · S/N 28-7615051 N730AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843792 N730CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881736 N730FNNguyen David · Cedar City, UTBuilt 1970 · S/N 28-26701 N730LKBay Aero Ventures LLC · Port Clinton, OHBuilt 1977 · S/N 28-7890070 N730MABennett Robert · Lutz, FLBuilt 2024 · S/N 2881697 N730NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843887 N730SASun Aircraft Management LLC · Ormond Beach, FLBuilt 2010 · S/N 2842363

Back to AD 87-08-08 R3