Skip to content

Registered aircraft · 40,395

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

N3935KKrog Steven L · Hartford, WIBuilt 1967 · S/N 28-23809 N3935QBeaufort Flight Training LLC · Beaufort, SCBuilt 1971 · S/N 17260035 N3936MAtd Pilot Training LLC · Kansas City, MOBuilt 1978 · S/N 28-7816386 N3936PTroyer Robert E · Toledo, WABuilt 1956 · S/N 22-3611 N3937ZBundy Jerrian M · Anchorage, AKBuilt 1962 · S/N 18-7783 N3938CHale Phil · Palm Bay, FLBuilt 2008 · S/N 70569 N3938KCdb Group Holdings LLC · Sheridan, WYBuilt 1967 · S/N 28-23813 N3938NSundance Aviation Inc · Richland, WABuilt 1968 · S/N 680065 N3938PSwoboda Matthias W · Green Bay, WIBuilt 1956 · S/N 22-3613 N3938QGreen Carl P · Columbia, MSBuilt 1971 · S/N 17260038 N3938ZCooper Donald A · Casper, WYBuilt 1962 · S/N 18-7784 N3939KRegistration Pending · Grand Prairie, TXRegistration pendingBuilt 1967 · S/N 28-23814 N3939RReid Edwin G Jr · Hollywood, MDBuilt 1970 · S/N 28-5850 N3939XArapahoe Flight Club LLC · Colorado Springs, COBuilt 1975 · S/N 28-7515434 N3939ZCarnine Daniel · Angora, NEBuilt 1962 · S/N 18-7785 N393AWRoe Elton L · Harrison, ARBuilt 1968 · S/N 252 N393HWilliams Fred V · Reno, NVBuilt 2022 · S/N 58P-111P/112P-P299 N393RCBarnes Thomas M · Pittsboro, NCBuilt 2001 · S/N 1176 N3940KAir Ventures Flying School LLC · Smithfield, RIBuilt 1967 · S/N 28-23764 N3940MCondair Flyers Inc · Latham, NYBuilt 1978 · S/N 28-7816388 N3940ZGrasser Edward K · Palmer, AKBuilt 1963 · S/N 18-7786 N3941KHawkins Allan S · Lizella, GABuilt 1967 · S/N 28-23816 N3942NFlying Services Inc · Wilmington, DEBuilt 1968 · S/N 680007 N3942QSullivan Donald Edward II · Edwards, ILBuilt 1971 · S/N 17260042 N3944FHenley Johnny · Trenton, NCBuilt 1976 · S/N 28-7615432 N3944KPeiker Laramie · Revillo, SDBuilt 1967 · S/N 28-23819 N3944QFeauto Aviation Inc · Saint Cloud, FLBuilt 1971 · S/N 17260044 N3944SAlpha Romeo LLC · Wray, COBuilt 1990 · S/N 728 N3944ZTasch Kenneth O · Chilton, WIBuilt 1962 · S/N 18-7801 N39456Lorber Robert M · East Brunswick, NJBuilt 1978 · S/N 28-7816660 N3945FBrougnton Eric S · Catlettsburg, KYBuilt 1976 · S/N 28-7690463 N3945KFisher Knute A · Kensington, CABuilt 1967 · S/N 28-23821 N3945PLiedtka Thomas M · Stevensville, MTBuilt 1956 · S/N 22-3620 N3945RJpx Aero Club Corp · East Hampton, NYBuilt 1970 · S/N 28-5854 N3945ZKramer Thomas K Trustee · Anchorage, AKS/N 18-7802 N39472Moore Tucker S · Keswick, VABuilt 1978 · S/N 28-7816662 N39474Hartwig Aircraft Fuel Cell Repair Inc · St AndrewsBuilt 1966 · S/N MB-23 N3947PGilger Douglas D II · Boyes, MTBuilt 1956 · S/N 22-3622 N3947ZVan Winkle James L · Wood Lake, NEBuilt 1962 · S/N 18-7805 N3948KMcilroy William E · Dyer, INBuilt 1967 · S/N 28-23824 N3948PMoore Roger D · Lubbock, TXBuilt 1956 · S/N 22-3623 N3948QCitabria Inc · Auburn, CABuilt 1971 · S/N 17260048 N3948ZLiedtka Mark T · Stevensville, MTBuilt 1962 · S/N 18-7806 N3949Sliger Thomas Edward · Turlock, CABuilt 1971 · S/N SSBI N39496Texter John F · Saint Ignace, MIBuilt 1978 · S/N 28-7890536 N3949PGriggs Luz V · Goddard, KSBuilt 1956 · S/N 22-3626 N3949QTuschen James E · Rockford, ILBuilt 1971 · S/N 17260049 N394DSP&R Operations Ltd · Muscatine, IABuilt 1980 · S/N 28-8116040 N3950QDieter Jason W · Midlothian, VAS/N 17260050 N39512Tcb Consulting LLC · Yorba Linda, CABuilt 1978 · S/N 28-7890537

Back to AD 79-10-03 R2