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.

N1847YN1847y LLC · Queensbury, NYFirst renewal noticeBuilt 1962 · S/N 17249447 N1848QHartley Paul · Bellevue, WABuilt 1977 · S/N 18503493 N1848RTallman Dale C · Wasilla, AKBuilt 1974 · S/N 18502563 N1848ZBritt Robert J · Augres, MIBuilt 1962 · S/N 205-0048 N1849FCrouse William F · Priest River, IDBuilt 1966 · S/N 21058749 N1849XRaymond Patrick H · Jerseyville, ILBuilt 1965 · S/N 18255949 N184AFG & M Aircraft Inc · Wheat Ridge, COBuilt 2003 · S/N 17281184 N184AKDe Man Cameron T · Bend, ORBuilt 1963 · S/N 18051302 N184CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283259 N184CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282174 N184DPRobertson Gary B · Canton, TXBuilt 1975 · S/N 18263817 N184JPSarita Aerial Contractors Inc · Casa Grande, AZBuilt 1979 · S/N 18052889 N184NWNorthwestern Michigan College · Traverse City, MIBuilt 2010 · S/N 172S11085 N184PWCardwell Aubrey Lynn · Spring Branch, TXBuilt 1979 · S/N 18266871 N184RDAfrican Parks Aviation Trustee · Cheyenne, WYBuilt 1999 · S/N 18280466 N184TMYates Christopher R · Huntington Beach, CABuilt 1956 · S/N 32302 N185Ellison Jeremy Trustee · Dayton, NVBuilt 1974 · S/N 18502582 N18500Thompson Dennis E · Anchorage, AKBuilt 1977 · S/N 18503305 N18501Dunbar Stephen E Trustee · Broken Arrow, OKS/N 15073894 N18502Smith Stewart K · Samson, ALBuilt 1972 · S/N 15073895 N18503Asejo Emmanuel · Kaaawa, HIBuilt 1972 · S/N 15073896 N18505Webb Terrell W · Albemarle, NCBuilt 1972 · S/N 15073897 N18506Mc Carley Kendel · Tucson, AZBuilt 1972 · S/N 15073898 N1850QVincz Shawn · Williams, INBuilt 1972 · S/N 177RG0250 N18510Moore Jack B · Irvine, CABuilt 1976 · S/N 17702539 N18518Sale Reported · Waterbury, CTSale reportedBuilt 1976 · S/N 17702540 N18519Chrystall Shane · Marysville, OHBuilt 1972 · S/N 15073909 N1851YEscapule Dustin L III · Florence, AZBuilt 1962 · S/N 17249451 N18521Island Air LLC · Eagan, MNBuilt 1979 · S/N 185-03812 N18522Carr Scott · Bells, TXBuilt 1972 · S/N 15073911 N18523Km50 Ventures LLC · Pensacola, FLBuilt 1976 · S/N 17702541 N18524Alpha International Aircraft Inc · Lewes, DES/N 15073913 N18527Bundy Richard S · Little Egg Harbor, NJBuilt 1972 · S/N 15073916 N18529Briers Scott Kevin · Conroe, TXBuilt 1977 · S/N 17702542 N1852FSymbot Management Inc · Dover, DENon-citizen corporation, flight hours not reportedBuilt 1966 · S/N 21058752 N1852QTalbot Mitchell R · Queen Creek, AZBuilt 1972 · S/N 177RG0252 N1852RHartman Craig T Trustee · Chugiak, AKBuilt 1975 · S/N 18502567 N1852XPhillips Lane · Dawson, TXBuilt 1965 · S/N 18255952 N1852YMinot Light Aviaiton LLC · Rockland, MABuilt 1962 · S/N 17249452 N18531National Test Pilot School · Mojave, CABuilt 1972 · S/N 15073920 N18533Booth Donald V · Denison, TXS/N 15073922 N18534Rupert Dinah J · New Plymouth, OHFirst renewal noticeBuilt 1972 · S/N 15073923 N18537Kirsch Richard D · Lisbon, NDBuilt 1972 · S/N 15073925 N1853CDavidson Gregg C · Pioneer, CAFirst renewal noticeBuilt 1953 · S/N 25997 N1853QSend North · Anchorage, AKBuilt 1975 · S/N U20602943 N1853YHurd Roger Mark · Bow, WABuilt 1962 · S/N 17249453 N18540Fisher Tracey R · Glenwood, IAS/N 15073928 N18546O'Sita Tade · Burnsville, MNFirst renewal noticeBuilt 1972 · S/N 15073934 N1854CBurns Linda J · Vernon, MIBuilt 1953 · S/N 25998 N1854FHarlan Bradley J · New Brighton, MNBuilt 1966 · S/N 21058754

Back to AD 79-10-14 R1