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.

N12931Walden David C · Mesa, AZBuilt 1973 · S/N 17262382 N12933Van Anda Aviation LLC · Apopka, FLBuilt 1973 · S/N 17262384 N12935Ray Aviation LLC · Burkett, TXBuilt 1973 · S/N 17262386 N12936Quinlan Patrick J · Cooper City, FLBuilt 1973 · S/N 17262387 N1293DAlder George A · Palmer, AKBuilt 1951 · S/N 19869 N1293FT-Craft Aero Club · Nampa, IDBuilt 1979 · S/N 17272987 N1293QCoxwell James L · Midlothian, TXBuilt 1971 · S/N 15072593 N1293SMeyer Raymond · Belding, MIBuilt 1976 · S/N 18264860 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 N1294QKimmons Anthony J · Bogue Chitto, MSBuilt 1971 · S/N 15072594 N1294SSheehan Dennis M · Stoughton, WIBuilt 1976 · S/N 18264861 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 N1295DBlessum Jay A · Minot, NDBuilt 1950 · S/N 19871 N1295URegistration Pending · Monroe, WIRegistration pendingBuilt 1976 · S/N 17266989 N12960Hennessee Timothy H · New Braunfels, TXBuilt 1973 · S/N 17262405 N12968Rtd Aviation LLC · Hillsborough, NJBuilt 1973 · S/N 17262413 N1296CLogan Tom B Trustee · Coeur D Alene, IDBuilt 1977 · S/N 17702699 N1296FWalker Brandon · Anchorage, AKBuilt 1975 · S/N 18502816 N1296QFey Brian F · Waycross, GABuilt 1971 · S/N 15072596 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 N1297DPerk LLC · Glendale, AZBuilt 1951 · S/N 19873 N1297FJprg Aviation Inc · Orlando, FLBuilt 1979 · S/N 17272990 N1297SAlpine Skylane LLC · Alpine, WYS/N 18264864 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 N1298DGlaser Gerald A · Sebastopol, CABuilt 1951 · S/N 19874 N1298MRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1975 · S/N 18264280 N1298SHighlane LLC · Phoenix, AZBuilt 1976 · S/N 18264865 N12991Usda Forest Service Fepp · Columbia, SCBuilt 1973 · S/N 17262432 N12997Wausau Flying Service Inc · Wausau, WIS/N 17262437 N1299MMoanaviation Inc · Tampa, FLBuilt 1977 · S/N 21061932 N1299SAero Guard Aviation Insurance LLC · Lincoln, NEBuilt 1976 · S/N 18264866 N1299URice Melvin G · Bridgeport, TXBuilt 1976 · S/N 17266993 N129AHN388vr LLC · Olalla, WABuilt 1963 · S/N 17251051 N129BAAdvise By Air LLC · Whittier, CABuilt 2004 · S/N 18281353 N129CSGoldenstein Steven H Jr · Jurupa Valley, CABuilt 1975 · S/N 18264167 N129ELTrooien-Smith Construction LLC · Seeley Lake, MTBuilt 1978 · S/N U20604374 N129FRWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 17275338 N129HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9667

Back to AD 79-10-14 R1