Skip to content

Registered aircraft · 6,349

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-25-02-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-25-02-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-25-02-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-25-02-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-25-02-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-25-02-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.

N39051Lynx Paw LLC · Wilmington, DEBuilt 1978 · S/N AA1C0204 N39058Karlin Dana M · Costa Mesa, CABuilt 1978 · S/N AA1C0206 N39064Fischer John W · Saint Charles, MOBuilt 1978 · S/N AA1C0210 N39065Kelly William A · Palmdale, CABuilt 1978 · S/N AA1C0211 N39067Miller Rondo T · Coon Rapids, MNBuilt 1941 · S/N 1828 N3906MCarroll Dan L · Soldotna, AKS/N 12-2805 N39070Wolff Karl W · Santa Fe, NMBuilt 1978 · S/N AA1C0143 N390EZJones Lawrence S · San Pedro, CABuilt 1984 · S/N 1390 N3910MHodges Larry W · Lees Summit, MOBuilt 1947 · S/N 12-2808 N3911MDeppmeyer Thomas · Woodgate, NYBuilt 1947 · S/N 12-2809 N3913MHagman Jeffrey W · Saint Bonifacius, MNBuilt 1947 · S/N 12-2811 N3915Crestair Air LLC · Dover, DEBuilt 2006 · S/N 2502B N3920MBergstedt Jon P · Anchorage, AKS/N 12-2588 N3921MJoslin David W · Seward, AKBuilt 1947 · S/N 12-2817 N3924MNiles Air LLC · Concord, NCBuilt 1947 · S/N 12-2826 N3933MLee Gary W Trustee · Oklahoma City, OKBuilt 1947 · S/N 12-2829 N3935MShuster David Joseph · Marmora, NJBuilt 1947 · S/N 12-2823 N3937MDowns Douglas · Fairbanks, AKS/N 12-2825 N3939MMclaughlin Scott A · Defiance, IABuilt 1947 · S/N 12-2591 N3941MHilterbrand Drew S · Ninilchik, AKBuilt 1947 · S/N 12-2832 N3942MKraft Duane J · Timber Lake, SDBuilt 1947 · S/N 12-2593 N3944MHebert Troxell S · Delta Jct, AKBuilt 1947 · S/N 12-2834 N3957MCarnahan Thomas L · Wasilla, AKBuilt 1947 · S/N 12-2856 N3971MAllen Richard P · Southampton, NJBuilt 1947 · S/N 12-2599 N3972MIntricate Bay Operating LLC · Saylorsburg, PAS/N 12-2900 N3978MSchrier Timothy M · Savage, MNBuilt 1947 · S/N 12-2901 N3978PNicklas William T · Rllng Hls Est, CABuilt 1977 · S/N 15279647 N3985MFurnas Jerry W · San Diego, CAS/N 12-2865 N398JMRohrs Jack L · Henderson, NVBuilt 2012 · S/N 398 N3992MRodgers Justin C · Fairbanks, AKBuilt 1947 · S/N 12-2872 N3997MHoward Charles M · Pittsburg, TXBuilt 1947 · S/N 12-2876 N399XHlavin Mark S Trustee · Lakewood Ranch, FLBuilt 1978 · S/N AA1C0192 N39AFTuskegee Airmen National Historical Museum Inc · Detroit, MIBuilt 1983 · S/N 9 N39BRSystems Research Corp · Wilmington, DEBuilt 1991 · S/N 122639 N39CFFedrigo John A · Moneta, VAS/N 38-79A0765 N39ESHowell Jeff D · Payette, IDBuilt 2010 · S/N 0100 N3HXWreyford James S · Marble Falls, TXBuilt 1947 · S/N 12-2555 N3KEBlevins Myrl Dean · Wytheville, VABuilt 1962 · S/N 22-9244 N3LCStimson Andrew J · Battle Ground, WABuilt 1970 · S/N AA1-0401 N3LYBurkey Jeffery C · Stuart, FLBuilt 1973 · S/N AA1B-0287 N3TTWitherspoon Dennis D · Shedd, ORBuilt 1973 · S/N 40 N3VXCoriell Lynn V · Columbus, OHBuilt 1968 · S/N 631 N3XXSchulze Jeffrey N · Ransomville, NYBuilt 1946 · S/N 12-811 N4000HSmith Clyde R Jr · Lock Haven, PABuilt 1948 · S/N 16-1 N4003MEly Gregory C · Calistoga, CAS/N 12-2880 N4013MCook Richard J II · Princeton, ILBuilt 1947 · S/N 12-2891 N4014MWright James Henry · Brooksville, FLBuilt 1947 · S/N 12-2892 N4017MBryant Theodore M · Wasilla, AKBuilt 1947 · S/N 12-2895 N4018MCesare Anthony D · Millinocket, MEBuilt 1947 · S/N 12-2896 N401CDMccartney Terry A · Spirit Lake, IDBuilt 2006 · S/N 1

Back to AD 80-25-02 R2