Skip to content

Registered aircraft · 25,367

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.

N12830All Sports Aviation LLC · Spokane, WABuilt 1973 · S/N 17262296 N12831Bryant Kevin L · Terry, MSBuilt 1973 · S/N 17262297 N12833Kling Aviation Inc · Friendswood, TXBuilt 1973 · S/N 17262299 N12834High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 17262300 N12836Schlemmer Diane · Roswell, GABuilt 1973 · S/N 17262301 N1283UAtutis Michael F · Baldwinsville, NYBuilt 1976 · S/N 17266978 N12840Lanier Aviation LLC · Cleveland, GABuilt 1973 · S/N 17262304 N12849Ripa Christopher J · East Harwich, MAFirst renewal noticeBuilt 1973 · S/N 17262311 N12860Solis Aviation LLC · Carroll, OHBuilt 1973 · S/N 17262319 N12865Flyright Aviation LLC · Columbus, OHBuilt 1973 · S/N 17262324 N12866Holmes Charles Trustee · Fort Madison, IABuilt 1973 · S/N 17262325 N12867Palm Grove Development Inc · Gray, GABuilt 1973 · S/N 17262326 N12868Gregg William V · Greensburg, PABuilt 1975 · S/N 17702390 N12871Bemidji Aviation Services Inc · Bemidji, MNBuilt 1973 · S/N 17262330 N12872Advanced Aviation And Aircraft Rental LLC · Lawrenceville, GABuilt 1973 · S/N 17262331 N12874Mentone Flying Club Inc · Rochester, INBuilt 1973 · S/N 17262333 N12875Career Flight Training And Aircraft Rental LLC · Naples, FLBuilt 1973 · S/N 17262334 N12876Aerolanding LLC · Enterprise, ALBuilt 1973 · S/N 17262335 N12878M&M Bear Necessities LLC · Newellton, LABuilt 1973 · S/N 17262337 N1287UTrekraken Aviation LLC · Scottsdale, AZBuilt 1976 · S/N 17266981 N12880Aerial Holdings LLC · Lewes, DEBuilt 1973 · S/N 17262339 N12883Rpm Aero LLC · Lincolnwood, ILBuilt 1973 · S/N 17262340 N12884Registered aircraftBuilt 1973 · S/N 17262341 N12885Above & Beyond Aviation LLC · Sandy Hook, CTBuilt 1973 · S/N 17262342 N12886Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17262343 N12887Slipstream Aviation LLC · Calera, ALBuilt 1973 · S/N 17262344 N1288ALaminar Training Solutions LLC · Murrieta, CABuilt 1983 · S/N 24-1364 N12893Weiss Lyle D · Faith, SDBuilt 1973 · S/N 17262348 N12897Foothill Aircraft Sales & Service Inc · Upland, CABuilt 1973 · S/N 17262352 N12898Nova Ivan · Hackensack, NJS/N 17262353 N12899Lyon Kimberly J · Layton, UTBuilt 1973 · S/N 17262354 N1289UKavak Air Inc · Middletown, DEBuilt 1982 · S/N 21064682 N1289XConner James B · Mishawaka, INBuilt 1963 · S/N 162 N128CGMontaez Torrez Raul · Guaynabo, PRBuilt 1968 · S/N 17256621 N128DMTransnovia LLC · Haslett, MIBuilt 1999 · S/N 1375-99 N128ESturges John A · Hayden, IDBuilt 1966 · S/N 1190 N128EEAlgab Holdings LLC · Newark, DEBuilt 1978 · S/N P21000133 N128EPPalicki Anthony J · Huntsville, ALBuilt 1985 · S/N 172-76482 N128HRDerenick Aviation LLC · Aguadilla, PRS/N 17262679 N128MAFca Flight Center Inc · Fitchburg, MABuilt 1975 · S/N 17263941 N128PBHayes Thomas G · Kerrville, TXBuilt 1966 · S/N 1283 N128PHWayne Terry · Belews Creek, NCBuilt 2023 · S/N 1218 N128RVande Hei Joshua G · Kaukauna, WIBuilt 1968 · S/N 17256984 N128SMHafford Jay T · Stevenson, WAS/N 1162-79 N128VMThomas Lucas G · Beebe, ARBuilt 2017 · S/N 585-2017 N12901American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262356 N12902Total Flight Aircraft Leasing LLC · Apex, NCBuilt 1973 · S/N 17262357 N12908M & R Management Consulting Inc · Fort Meade, FLNon-citizen corporation, flight hours not reportedS/N 17262362 N1290XJr Aviation LLC · Benton, KSBuilt 1963 · S/N 163 N12916Jacobs Airways Inc · Wilson, WIBuilt 1973 · S/N 17262369

Back to AD 80-25-07 R1