Skip to content

Registered aircraft · 40,473

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-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N56798Warrior Airways LLC · Coral Springs, FLBuilt 1973 · S/N 28-7415013 N5679DAce Flight Center Inc · Saint Thomas, VIFirst renewal noticeBuilt 1959 · S/N TD-188 N5679PKuehnert Stefan · Clarkesville, GABuilt 1959 · S/N 24-751 N5679QLambert John D · El Paso, TXBuilt 1965 · S/N 3038 N5679SWinters Kevin L · Nine Mile Falls, WABuilt 1966 · S/N MB-122 N5679UInverted Holdings LLC · Newnan, GABuilt 1969 · S/N 28-26476 N567DHDoyel Landy N · Klamath Falls, ORBuilt 1998 · S/N 5152 N567GAAdkins Gordon L · Kenova, WVBuilt 2004 · S/N 3668 N567RVMarini Robert A · Brighton, COBuilt 1991 · S/N 20567-RV6 N567VEEngbring Jered · Durango, COBuilt 2026 · S/N JE001 N56809Hudak Susanne Marie · Gold Canyon, AZS/N 28-7425041 N5680VTime To Fly LLC · Cleveland, MSBuilt 1977 · S/N 28-7716198 N5680WGoines Courtnee J · Jacksonville, FLS/N 28-931 N5680YSchildberg Gregory M · Casey, IABuilt 1965 · S/N 18-8292 N5681QSteixner Jessica M · Madison, TNBuilt 1965 · S/N 3039 N5681VNewell & Sons · Roxboro, NCBuilt 1977 · S/N 28-7790495 N56821Cowlin Aviation LLC · Houston, TXBuilt 1973 · S/N 28-7425046 N56828Gillette Daniel R · Chillicothe, ILBuilt 1973 · S/N 28-7425048 N5682VSgm Contractors LLC · Great Falls, VABuilt 1977 · S/N 28-7790496 N5682WRiggin Flight Service Inc · Madison, SDBuilt 1962 · S/N 28-938 N56831Burns Robert A · Fort Myers, FLFirst renewal noticeBuilt 1973 · S/N 28-7415015 N5683WYanta Chris · Rockport, TXBuilt 1962 · S/N 28-940 N56847Nepsund Michael L · Park Rapids, MNBuilt 1973 · S/N 28-7415017 N56849Macair Aviation LLC · Xenia, OHBuilt 1973 · S/N 28-7415018 N5684WSeverino Racli · Closter, NJBuilt 1963 · S/N 28-948 N5685PWalker Richard E · Quanah, TXBuilt 1959 · S/N 24-757 N5685SGreen Taylor · Olympia, WABuilt 1966 · S/N MB-125 N5685UTres Amigos Flying Club LLC · Redding, CABuilt 1969 · S/N 28-26482 N5685WRempel Steven P · Prague, OKBuilt 1962 · S/N 28-953 N56860Horst Michael D · Chambersburg, PABuilt 1973 · S/N 28-7415019 N56861Wingsleasing LLC · Wichita, KSBuilt 1973 · S/N 28-7405035 N5686UHobbs Stanley T · Middleburg, FLBuilt 1969 · S/N 28-26483 N5686WPromedical Inc · Pfafftown, NCBuilt 1962 · S/N 28-954 N5687QRegistered aircraftBuilt 1965 · S/N 3042 N5687SRobbins Warren N · Chandler, AZBuilt 1966 · S/N MB-127 N56887Leavitt Teyvin M · Coeur D Alene, IDS/N 28-7425059 N5688STanneberg Larry · Coulee City, WABuilt 1966 · S/N MB-128 N5688WSerendipity Rentals LLC · Denver, COBuilt 1963 · S/N 28-1013 N56898Evans Katrina · Watkinsville, GABuilt 1973 · S/N 28-7425061 N56899Mcdonald George · Inverness, FLBuilt 1973 · S/N 28-7415022 N5689PMarsala Joseph · Uxbridge, MABuilt 1959 · S/N 24-761 N5689QReynolds Shawn E · Ventura, CAS/N 3043 N5689UGeorge Marc J · Harker Heights, TXBuilt 1969 · S/N 28-26486 N5689VStardust Aviation LLC · Farmingdale, NYBuilt 1977 · S/N 28-7790498 N568FLAir Ventures Flying School LLC · Smithfield, RIBuilt 1971 · S/N 28-7125411 N568LTLuckie Mark O · Ashland, KSBuilt 2001 · S/N 25177 N568WACarver Clarence K Trustee · Lutz, FLS/N 28-7325162 N56900Roberts Marcus · Vancouver, WAS/N 28-7415023 N56902G R Martin & Associates LLC · West Plains, MOS/N 28-7405037 N5690UPena Flight Partners LLC · Oakland, CABuilt 1970 · S/N 28-26488

Back to AD 80-04-03 R2