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.

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 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 N7391LAbdulshafi Ahmed Jason · Oxnard, CABuilt 1978 · S/N A1520808 N7391PShph LLC · Edwards, ILBuilt 1978 · S/N P21000011 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 N73929Jprg Aviation Inc · Orlando, FLBuilt 1976 · S/N 17267753 N7392LKnowles Charles M Jr · Chapmanville, WVS/N A1520809 N73930Bunke Paul R Trustee · Harrison, OHBuilt 1976 · S/N 17267754 N73934Hanson Alexander P · Bremerton, WABuilt 1976 · S/N 17267755 N73938Preston Richard R Trustee · Albuquerque, NMBuilt 1976 · S/N 17267757 N7393GBlue Wings LLC · Brecksville, OHBuilt 1970 · S/N 17259093 N73946Carastro Enterprises LLC · Montgomery, ALBuilt 1976 · S/N 17267761 N7395DAviation Management Group LLC · Endicott, NYBuilt 1979 · S/N 17272919 N7395GBrewer James · Myakka City, FLBuilt 1970 · S/N 17259095 N7395LCatherines Aviation Services LLC · Sewanee, TNBuilt 1978 · S/N A1520812 N7395XBrl Air LLC · Onsted, MIBuilt 1977 · S/N R18200097 N73964Coachron Investments LLC · Grosse Ile, MIBuilt 1976 · S/N 17267766 N73977Bfl Aviation LLC · Bakersfield, CABuilt 1976 · S/N 17267769 N7397BAerolina Inc · Hendersonville, NCBuilt 1977 · S/N A1520766 N7397GMarkowitz Edwin P · Luray, VABuilt 1970 · S/N 17259097 N73981Gagnon Michael J · Merrimack, NHBuilt 1976 · S/N 17267770 N7398LNelson Gregory J · Newcastle, CABuilt 1978 · S/N A1520815 N739ADSeven Three Nine Alpha Delta Club Inc · Memphis, TNFirst renewal noticeBuilt 1978 · S/N 17270382 N739AFSilver Isaac M · Satellite Beach, FLBuilt 1978 · S/N 17270384

Back to AD 80-25-07 R1