Skip to content

Registered aircraft · 56,580

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.

N3288SEpple William E · Roggen, COBuilt 1964 · S/N 18255788 N3288UVetch Rod F · Ranchester, WYBuilt 1963 · S/N 18254688 N32897Mach Point Nine LLC · Phoenix, AZS/N 15065989 N3289AKennedy Kelly · Wheatland, WYBuilt 1953 · S/N 25933 N3289SDouble Lazy H LLC · Delta, COBuilt 1964 · S/N 18255789 N3289URutenbeck Terry L · Wiggins, COBuilt 1963 · S/N 18254689 N3289YHasselbring Ted S · Nashville, TNBuilt 1962 · S/N 18254289 N328CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283309 N328DDLandsburg Custom Services LLC · Sandusky, MIBuilt 1973 · S/N 17262401 N328FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13220 N328LDuffield Brian · Eastvale, CABuilt 1973 · S/N 18262043 N328MEFlying Start Aero Services LLC · Reno, NVS/N 172S8575 N328TASuburban Air Corp · Castro Valley, CABuilt 2003 · S/N 172S9328 N32909Zamarripa Hector · Brownsville, TXBuilt 1970 · S/N 18260423 N3290FCline Mark A · Winston Salem, NCBuilt 1967 · S/N R172-0222 N3290JFitzgerald Jacob J · Pullman, WABuilt 1966 · S/N 15065990 N3291EKukuchka Ronald G · Tunkhannock, PABuilt 1978 · S/N 17271493 N3291LSun Baron · Arcadia, CABuilt 1967 · S/N 17256191 N3291SRegistration Pending · Highland, ILRegistration pendingBuilt 1964 · S/N 18255791 N3291ZMiller Andy D · Marana, AZBuilt 1973 · S/N 15075105 N3292TCelestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1967 · S/N 17700592 N3292UAnnecchini Frank C Jr · Overland Park, KSBuilt 1963 · S/N 18254692 N3293DGuilliams Carl · Gilbert, AZBuilt 1955 · S/N 32091 N3293YKiedinger John D · Burleson, TXS/N 18254293 N3294TWolniansky Peter W · Ocean Grove, NJS/N 17700594 N3294UWidener Christine A · Tucson, AZBuilt 1963 · S/N 18254694 N3295JClonts Kim E · Knox City, TXS/N 15065995 N3295YReid Brian M · Boise, IDS/N 18254295 N3296SBeekman Steven J · Stephenson, MIBuilt 1964 · S/N 18255796 N3296UBierer David E · Victor, MTBuilt 1963 · S/N 18254696 N3296YBeckord Aaron P · Tacoma, WABuilt 1962 · S/N 18254296 N3297LRaymond Patrick H · Jerseyville, ILBuilt 1967 · S/N 17256197 N3297TBurgdorf Dale A · Plano, TXBuilt 1967 · S/N 17700597 N3297YMust Dash Rides Flying Club LLC · Raleigh, NCBuilt 1962 · S/N 18254297 N3298LThompson Edward E · Buxton, MEBuilt 1967 · S/N 17256198 N3298SHolloway Cody L · Belle Plaine, KSBuilt 1964 · S/N 18255798 N3298T515 Aviation LLC · Dexter, IABuilt 1967 · S/N 17700598 N3299EBeglin Bruce W · Oxford, MDBuilt 1978 · S/N 17271495 N3299JEdwards Wallace · Commerce, MIS/N 15065999 N3299LHarrington David J · Albuquerque, NMBuilt 1967 · S/N 17256199 N3299SS V Aeronautics LLC · Afton, WYBuilt 1964 · S/N 18255799 N3299TSale Reported · Daytona Beach, FLSale reported, canceledBuilt 1967 · S/N 17700599 N3299URichardson Ronnie L Jr · East Wenatchee, WAFirst renewal noticeBuilt 1963 · S/N 18254699 N3299VChannel City Flyers Inc · Goleta, CABuilt 1974 · S/N 15076452 N329DJBritt Matthew W · Trenton, SCBuilt 1976 · S/N 177RG0845 N329JFJ F Aviation Inc · Joliet, ILBuilt 1975 · S/N 17265835 N329MABarr Air Patrol LLC · Mesquite, TXBuilt 1998 · S/N 18280102 N329MECentral Iowa Aviation LLC · Ankeny, IABuilt 2000 · S/N 172S8461 N329WPPhillips J Weston · West Jefferson, NCBuilt 2025 · S/N 18283329 N32AKHummel Karl · Brooklyn, NYBuilt 1973 · S/N 18261935

Back to AD 79-10-14 R1