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.

N7208JWelby Samantha · Eastampton, NJBuilt 1968 · S/N 28-24541 N7208WSky View Aviation LLC · Porter, OKS/N 28-1117 N7209FNew Garden Township · Landenberg, PABuilt 1968 · S/N 28-25118 N720FLExecutive Flight Training & Services LLC · Sanford, NCBuilt 1972 · S/N 28-7225401 N720GCCox Gary E · Davis, CABuilt 1972 · S/N 28R-7235317 N720GPCharlie Hotel Corp · Wilmington, DEBuilt 1977 · S/N 28-7790366 N720JBSchoettle Steve P · Heber Springs, ARBuilt 1979 · S/N 32-7940150 N720KMTrubee Jay G Trustee · Palm Desert, CABuilt 2002 · S/N 3257300 N720PAValiair Lc Trustee · Casper, WYBuilt 2000 · S/N 2843386 N720SHBrooke James B · Salisbury, MDBuilt 1997 · S/N 3246085 N720UOhio University · Albany, OHBuilt 2005 · S/N 2842223 N720WDThorntons Aircraft LLC · Tuscaloosa, ALBuilt 2003 · S/N 3257327 N7210FCedar Yopanz Flying Club LLC · Las Vegas, NVBuilt 1968 · S/N 28-25119 N7210HMenzie Bradley J · Sublette, KSFirst renewal noticeBuilt 1976 · S/N 287690255 N7210JBoling Kenneth A · Greenbrier, ARBuilt 1968 · S/N 28-24543 N7210WN7210w Corp · Selma, NCBuilt 1963 · S/N 28-1355 N7211JGolden Arrow Transportation · Plainfield, NJBuilt 1968 · S/N 28-24545 N7212FDe Valle Rafael · Columbus, GABuilt 1968 · S/N 28-25121 N7212JF7 Aviation LLC · Kalispell, MTBuilt 1968 · S/N 28-24546 N7212WFerki Joseph J · Franklin, VABuilt 1963 · S/N 28-1154 N7213WSmith Scott V · Presque Isle, MEBuilt 1963 · S/N 28-1155 N7214JFalcon Flyers LLC · Hamilton, MTBuilt 1968 · S/N 28-24549 N7215FGailie Thomas E · Middletown, NYS/N 28-25125 N7216FBravo Aviation Assets LLC · Akron, OHBuilt 1968 · S/N 28-25126 N7216JCaden Aviation Services LLC · Dallas, TXBuilt 1968 · S/N 28-24551 N7216PFerrara Antonio · Granbury, TXBuilt 1963 · S/N 28-1433 N7216WBim Merle Robert W III · Piqua, OHBuilt 1963 · S/N 28-1030 N7217FWheeler Samuel C · O Fallon, MOBuilt 1968 · S/N 28-25127 N7217JAvionraton LLC · Valparaiso, INBuilt 1968 · S/N 28-24553 N7218JSullivan Michael D · Braddyville, IABuilt 1968 · S/N 28-24554 N7218WIsaacs Gorden R · Dillingham, AKBuilt 1963 · S/N 28-1033 N7219JJohnson Eric A · Shell Knob, MOBuilt 1968 · S/N 28-24555 N721FJ8th Dimension Enterprises LLC · Aurora, ORBuilt 2021 · S/N 28020027 N721JDBrand Technicians LLC · Encino, CABuilt 2000 · S/N 2843410 N721NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881309 N721SMBlue Skies Flying Services Inc · Lake In The Hills, ILBuilt 2000 · S/N 2843337 N721TTFlight School Of Gwinnett · Lawrenceville, GAS/N 28-7505093 N7220FSmith Craig D · Lucedale, MSBuilt 1968 · S/N 28-25131 N7221CPtg LLC · Princeton Junction, NJBuilt 1975 · S/N 28-7615047 N7221JWilliams Maria M · Kernersville, NCBuilt 1968 · S/N 28-24557 N7222JAviation Partners Llp · Bismarck, NDBuilt 1968 · S/N 28-24558 N7223FBrown Richard G · Irvine, CABuilt 1976 · S/N 28-7725087 N7223WRajuan Oren · Sacramento, CAFirst renewal noticeBuilt 1963 · S/N 28-1038 N7224FBiviano Joseph J · Tehachapi, CAS/N 28-25136 N7224MAffordable Construction Services Inc · Humboldt, TNS/N 32-108 N7225WOshaughnessy Breandan · Allen, TXBuilt 1963 · S/N 28-1041 N7226JChristffersen Robert H · Tacoma, WABuilt 1968 · S/N 28-24562 N7226WStuart Ryan C · Snowflake, AZBuilt 1963 · S/N 28-1143 N7227FStrange Keith · Lincoln, MEBuilt 1968 · S/N 28-25139 N7227JRad Aviation LLC · Abbeville, ALS/N 28-24563

Back to AD 87-08-08 R3