Skip to content

Registered aircraft · 54,015

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

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 N738YXHogan Patrick B · Simpsonville, SCBuilt 1978 · S/N 17270352 N738YZHotton Ralph A · Canton, MIBuilt 1978 · S/N 17270354 N738ZASale Reported · Ogden, UTSale reportedBuilt 1978 · S/N 17270355 N738ZBDyberg Mike · Mount Vernon, WABuilt 1979 · S/N R18200976 N738ZCN738zc LLC · Tallahassee, FLBuilt 1978 · S/N 17270357 N738ZDChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N 17270358 N738ZELagow Virgil M Ll · Muskogee, OKS/N 17270359 N738ZFMann Don R · Mount Vernon, OHBuilt 1978 · S/N 17270360 N738ZGPopescu Daniel · Nokesville, VABuilt 1978 · S/N 17270361 N738ZHRegistration Pending · La Porte, TXRegistration pendingBuilt 1978 · S/N 17270362 N738ZLGoyal Vishal · Walnut Creek, CABuilt 1978 · S/N 17270365 N738ZMAero Lease And Trading LLC · Miami, FLBuilt 1978 · S/N 17270366 N738ZNRobins David B · Lander, WYBuilt 1978 · S/N 17270367 N738ZQRieman Joel · Lompoc, CABuilt 1978 · S/N 17270369 N738ZRFicus Point Aviation Corporation Inc · Middletown, DEBuilt 1978 · S/N 17270370

Back to AD 87-20-03 R2