Skip to content

Registered aircraft · 20,687

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N738WJSpann Leonard D · Little Rock, ARBuilt 1978 · S/N 17270291 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 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 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 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 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 N738ZTSp Airparts LLC · Moscow, IDBuilt 1978 · S/N 17270372 N738ZUSkydance Aviation LLC · Chesapeake, VABuilt 1978 · S/N 17270373 N738ZYRegistration Pending · Syracuse, NYRegistration pendingBuilt 1978 · S/N 17270377 N73900Dewey William B · Santa Barbara, CABuilt 1977 · S/N 17267737 N73904Vaayu Aviation LLC · Newark, CABuilt 1976 · S/N 17267739 N73910Arispe Aviation LLC · Mckinney, TXBuilt 1976 · S/N 17267741 N73917Wingsleasing LLC · Wichita, KSBuilt 1976 · S/N 17267744 N7391AMitchell Vernon · Waxahachie, TXBuilt 1957 · S/N 29491 N7391TAngell Toby L · Stillwater, OKBuilt 1959 · S/N 46991 N73922Mouton Charles J Jr · Gladewater, TXBuilt 1976 · S/N 17267746 N73923Professional Aviation Aircraft Services Ltd · New Philadelphia, OHBuilt 1976 · S/N 17267747 N73924Mack Aviation Holdings LLC · Atlanta, GABuilt 1976 · S/N 17267748 N73925Wings Over Texas Holdings LLC · Denton, TXS/N 17267749

Back to AD 90-06-03 R1