Skip to content

Registered aircraft · 40,481

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.

N12940Buffoon Flying Club · Mansfield, OHBuilt 1973 · S/N 17262388 N12943Titsworth R G · Seekonk, MABuilt 1973 · S/N 17262415 N12947Alltek Lebelle Ltd · Wilmington, DEBuilt 1973 · S/N 17262393 N1294CJel Imaging Services LLC · Rochester, NYFirst renewal noticeBuilt 1977 · S/N 17702698 N1294FClover Park Technical College · Lakewood, WABuilt 1979 · S/N 17272988 N12951Huestis Peggy J · Havre, MTS/N 17262397 N12952Wesselhoff Rick · Sedona, AZBuilt 1973 · S/N 17262398 N12953Witmer Travis R · Odenton, MDBuilt 1973 · S/N 17262399 N12955American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262400 N1295AJenski Kobie · Sutton, AKBuilt 1951 · S/N 18-1098 N1295TLutz Brian · Carmel, INBuilt 1972 · S/N 28-7205278 N1295UWolff Timothy W Trustee · Monroe, WIBuilt 1976 · S/N 17266989 N12960Hennessee Timothy H · New Braunfels, TXBuilt 1973 · S/N 17262405 N12968Rtd Aviation LLC · Hillsborough, NJBuilt 1973 · S/N 17262413 N1296UKirk Claire Y · Huntington Beach, CABuilt 1976 · S/N 17266990 N12973Mor Aviation LLC · Gaithersburg, MDBuilt 1973 · S/N 17262418 N12974Forest Ken W · Wales, NDBuilt 1972 · S/N 17262419 N12976Wanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1973 · S/N 17262421 N1297FJprg Aviation Inc · Orlando, FLBuilt 1979 · S/N 17272990 N12983Haman Aviation Services LLC · Nokomis, FLBuilt 1973 · S/N 17262427 N12984Go Fly Az LLC · Gilbert, AZBuilt 1975 · S/N 17702394 N12985Alamakee Flyers · Waukon, IABuilt 1973 · S/N 17262429 N12991Usda Forest Service Fepp · Columbia, SCBuilt 1973 · S/N 17262432 N12997Wausau Flying Service Inc · Wausau, WIS/N 17262437 N1299URice Melvin G · Bridgeport, TXBuilt 1976 · S/N 17266993 N1299XMunoz David · Corona, CAS/N 2680 N129CCChilds David E · Amber, OKBuilt 2002 · S/N 9951CC N129DDDruckenbrodt Donald D · Fredericksburg, TXS/N 1393 N129FRWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 17275338 N129MAAttwood Nicholas John · Ashburn, VAS/N 2890219 N129MSWinging It LLC · Kalispell, MTBuilt 2004 · S/N 3712 N129MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 4496172 N129SAero Quest LLC · Olive Branch, MSBuilt 1974 · S/N 17263118 N129SLLee Aero LLC · Wichita, KSBuilt 1979 · S/N 17273503 N129SYDaigle Danny · Greenville, MEBuilt 1978 · S/N 17270741 N129YEBuell Travis W · Harper, TXBuilt 2002 · S/N 3334 N12ADAltizer John N · The Woodlands, TXBuilt 1994 · S/N JWA-2 N12AKBurk Ross T · Casper, WYS/N 5695 N12BJValentour Lance F · Naperville, ILBuilt 1974 · S/N 17264570 N12BVRoberts William O · Lexington, VAS/N 0241 N12DPKish Gary A · Montrose, MIBuilt 1975 · S/N 1212D N12DSBuckbee Robert E · College Station, TXBuilt 1984 · S/N 27 N12ERPropelling The Gospel Missions Inc · Standish, MEBuilt 1976 · S/N 28-7615099 N12FMDelaware State University · Dover, DEBuilt 1978 · S/N 28-7816439 N12GANy Flying Tigers LLC · Ronkonkoma, NYBuilt 1977 · S/N AA5B0635 N12GCNorman Ashton J · Zanesville, OHBuilt 2000 · S/N 2264 N12GLHayden Debra J · Utica, KYBuilt 1995 · S/N JR-2 N12GNNauta Gordon Wayne · Palmdale, CABuilt 1977 · S/N 112 N12HHWilliams Jeffrey · Florence, ALBuilt 1989 · S/N 1688 N12HRHarben Grover S III · Gainesville, GABuilt 1991 · S/N 1664

Back to AD 80-04-03 R2