Skip to content

Registered aircraft · 25,369

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:80-25-07-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1') 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:80-25-07-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
  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:80-25-07-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
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.

N738UDAffection Above Aviation Inc · Yukon, OKBuilt 1978 · S/N 17270240 N738UESteinkamp Loren L · Fairmont, MNBuilt 1978 · S/N 17270241 N738UHSale Reported · Calabasas, CASale reportedBuilt 1978 · S/N 17270244 N738URCooper William J Jr · Littleton, NCBuilt 1978 · S/N 17270252 N738UTWright Flyer LLC · Palm Coast, FLBuilt 1978 · S/N 17270254 N738UUCiuccio Louis V · Old Forge, PABuilt 1979 · S/N R18200963 N738UWAircraft Management Services Inc · Milton, FLBuilt 1978 · S/N 17270257 N738UYOptima Aviation LLC DBA · Lewisville, TXBuilt 1978 · S/N 17270259 N738VAFive Rivers Flight Training LLC · Livermore, CABuilt 1978 · S/N 17270261 N738VBBrafa Frank T · Leesville, LABuilt 1978 · S/N 17270262 N738VCMarlin Walter E II · Locust Grove, GABuilt 1978 · S/N 17270263 N738VGTepper Steven · Freehold, NJBuilt 1979 · S/N R18200965 N738VJCommand-Aire LLC · Seattle, WABuilt 1978 · S/N 17270269 N738VLBasler Leon E · Sainte Genevieve, MOBuilt 1978 · S/N 17270271 N738VRWoodward Tyler James · Norman, OKBuilt 1978 · S/N 17270276 N738VTStrutin Millard Desmond · Hackettstown, NJBuilt 1979 · S/N R18200966 N738VUFive Rivers Flight Training LLC · Livermore, CABuilt 1978 · S/N 17270279 N738VVPureflight Aviation Training LLC · Newberg, ORBuilt 1978 · S/N 17270280 N738VWAwnf LLC · Burleson, TXBuilt 1979 · S/N R18200967 N738VYRpm Aero LLC · Lincolnwood, ILBuilt 1978 · S/N 17270283 N738WCBrb Grand-Air LLC · Indiantown, FLBuilt 1978 · S/N 17270286 N738WEBray Aviation LLC · Calera, OKBuilt 1978 · S/N 17270288 N738WGZlock David · Lakeville, MNBuilt 1978 · S/N 17270289 N738WJSpann Leonard D · Little Rock, ARBuilt 1978 · S/N 17270291 N738WKMallette Christopher Lee · Saint Rose, LABuilt 1979 · S/N R18200969 N738WLBrenair Inc · Mcalester, OKBuilt 1978 · S/N 17270293 N738WMMayers Trevor D · Miami, FLS/N 17270294 N738WNSkywarrior Flight Training LLC · Pensacola, FLBuilt 1978 · S/N 17270295 N738WRRoberts Dwight C · Seminole, OKS/N 17270298 N738WVJohnston John A · Raleigh, NCBuilt 1979 · S/N R18200971 N738WYIsland Aircraft LLC · Anchorage, AKFirst renewal noticeBuilt 1978 · S/N 17270305 N738WZPitman Steven M · Lyman, SCBuilt 1978 · S/N 17270306 N738XAHyldburg Aviation · Plymouth, MABuilt 1978 · S/N 17270307 N738XCLance Vaculin LLC D/B/A · Murray, UTBuilt 1979 · S/N R18200972 N738XDMls Aviation LLC · Yorba Linda, CABuilt 1978 · S/N 17270310 N738XFTynan Flyers LLC · Tynan, TXBuilt 1978 · S/N 17270312 N738XGWest Central Georgia Flying Club · Thomaston, GABuilt 1978 · S/N 17270313 N738XKBailey James D Trustee · Marana, AZBuilt 1978 · S/N 17270316 N738XLM&A Aviation LLC · Vine Grove, KYBuilt 1978 · S/N 17270317 N738XNLuther Edwin H · Bristol, TNBuilt 1979 · S/N R18200973 N738YBMark Stoughton · Salley, SCBuilt 1978 · S/N 17270332 N738YCN738yc LLC · Fresno, CABuilt 1978 · S/N 17270333 N738YHWebster Deryl Thomas · Angola, INBuilt 1978 · S/N 17270338 N738YJOzarka College · Melbourne, ARBuilt 1978 · S/N 17270339 N738YLCarter Flygare Inc · Sacramento, CABuilt 1978 · S/N 17270341 N738YPFuselier Byron · Rayne, LABuilt 1978 · S/N 17270344 N738YRYankee Romeo LLC · Wilmington, DEBuilt 1978 · S/N 17270346 N738YSHood Jerry R · Double Springs, ALBuilt 1978 · S/N 17270347 N738YTB2fh Ltd · Allentown, NJBuilt 1978 · S/N 17270348 N738YWLeemon Kenneth V · Scottsdale, AZBuilt 1978 · S/N 17270351

Back to AD 80-25-07 R1