Skip to content

Registered aircraft · 40,396

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

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 N7390JViets Richard C · Bloomer, WIBuilt 1968 · S/N 28-24752 N7390WRegistration Pending · Concord, NCRegistration pendingBuilt 1963 · S/N 28-1275 N73910Arispe Aviation LLC · Mckinney, TXBuilt 1976 · S/N 17267741 N73917Wingsleasing LLC · Wichita, KSBuilt 1976 · S/N 17267744 N7391DJohnson Robert D Trustee · Anchorage, AKBuilt 1957 · S/N 18-5756 N7391JDenke Larry · Long Valley, SDBuilt 1968 · S/N 28-24754 N7391KLandry Matthew A · Soldotna, AKS/N 20-300 N7391WDippolito Mario M · Sherwood, ARBuilt 1963 · S/N 28-1276 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 N73926Hatanaka Brandon C · Loveland, COBuilt 1976 · S/N 17267750 N73927Abcd Ventures LLC · Ada, OKBuilt 1976 · S/N 17267751 N73928Air Peanut Ltd · Wilmington, DEBuilt 1976 · S/N 17267752

Back to AD 79-10-03 R2