Skip to content

Registered aircraft · 56,578

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

N12801Cone Ted · Wayne, NJBuilt 1973 · S/N 17262271 N12805Bemidji Aviation Services Inc · Bemidji, MNBuilt 1973 · S/N 17262275 N1280KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13064 N1280YAutumn Crucus LLC · Cincinnati, OHS/N 15059680 N12819Stewart Todd L · Mooresville, NCS/N 17262288 N1281DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1951 · S/N 19857 N1281MWadleigh John M · Marana, AZBuilt 1970 · S/N 33701281 N1281QMaranatha Insurance Services Inc · Rancho Cucamonga, CABuilt 2006 · S/N 172S10333 N1281SChief Cornerstone LLC · Billings, MTBuilt 1976 · S/N 18264849 N12820US Aviation Group LLC · Denton, TXBuilt 1973 · S/N 17262289 N12821Hayslett Norman L · Roscoe, MOBuilt 1973 · S/N 17262290 N12822Courtney Aviation LLC · Columbia, CABuilt 1973 · S/N 17262291 N1282FRainbow River Lodge Aviation LLC · Alpine, UTS/N 18502806 N1282URutledge James K Trustee · Colfax, CABuilt 1976 · S/N 17266977 N1282YShewalter Nicholas · Frankfort, MIS/N 15059682 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 N1283QMacaruso Matthew H · Warwick, RIBuilt 1971 · S/N 15072583 N1283UAtutis Michael F · Baldwinsville, NYBuilt 1976 · S/N 17266978 N12840Lanier Aviation LLC · Cleveland, GABuilt 1973 · S/N 17262304 N12849Ripa Christopher J · East Harwich, MABuilt 1973 · S/N 17262311 N1284QHogan Resources Inc · Bedford Hills, NYBuilt 1971 · S/N 15072584 N1284TWhite Wayne A · Loyalton, CABuilt 1959 · S/N 52016 N1284YBeamer Enterprises LLC · Ada, OKBuilt 1962 · S/N 15059684 N1285FWill Rittner E · Sevierville, TNBuilt 1975 · S/N 18502809 N1285QDavis Allen J · Weidman, MIBuilt 1971 · S/N 15072585 N1285TGonzalez Paul · Peachtree City, GABuilt 1962 · S/N 15059685 N1285YBartosh Larry M · Abbott, TXBuilt 1963 · S/N 17251038 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 N1286DPolicani Desmond M · Tacoma, WABuilt 1951 · S/N 19862 N1286FTaylor Aviation Inc · Mazama, WAFirst renewal noticeBuilt 1975 · S/N 18502810 N1286YRamaswamy Gautam · Clearwater Beach, FLBuilt 1962 · S/N 15059686 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 N1287ECrown Coast LLC · Costa Mesa, CABuilt 2006 · S/N 172S10335 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

Back to AD 79-10-14 R1