Skip to content

Registered aircraft · 471

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:85-11-07-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:85-11-07-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:85-11-07-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:85-11-07-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:85-11-07-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:85-11-07-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.

N6320PSims Jacob Trustee · Montrose, COBuilt 1978 · S/N P21000168 N6328PSabath Kenneth J Trustee · Powell, WYBuilt 1978 · S/N P21000170 N6336UBravo Whiskey LLC · Missoula, MTBuilt 1985 · S/N 21064937 N6353UBas Part Sales LLC · Greeley, COBuilt 1985 · S/N 21064941 N6359WScarlett Cameron O · Madison, WIBuilt 1981 · S/N P21000757 N6365UPino Carlos R · Santa Fe, NMBuilt 1985 · S/N 21064944 N6385PBada Alfredo · Mcallen, TXBuilt 1978 · S/N P21000173 N6389WSpenco Inc · Sale Creek, TNBuilt 1981 · S/N P21000764 N6398WPivac Jorge I · Chandler, AZBuilt 1982 · S/N P21000767 N6399KI B Development LLC · Monahans, TXBuilt 1979 · S/N P21000397 N639FSC&Bh LLC · Vernal, UTBuilt 1980 · S/N P210-00639 N6409WBreedlove Joe · Skiatook, OKBuilt 1981 · S/N P21000770 N6413PAlta Air LLC · Boise, IDBuilt 1978 · S/N P21000176 N6416WGallien Anthony · Livermore, CABuilt 1981 · S/N P21000773 N642DSJgm Aviation LLC · The Woodlands, TXBuilt 1980 · S/N P21000510 N6431PHhd Aviation LLC · Hamilton, OHBuilt 1978 · S/N P21000182 N6434RCutlass Aviation LLC · Auburn, ALBuilt 1985 · S/N 21064926 N6444WBas Part Sales LLC · Greeley, COBuilt 1982 · S/N P210-00781 N6446WRichter Aviation Inc · Maxwell, CABuilt 1981 · S/N P21000782 N644VCElder Daniel R · Kalispell, MTBuilt 1979 · S/N P21000249 N6456UN909dw LLC · Helena, MTBuilt 1985 · S/N 21064954 N6476WWill Investments Inc · Englewood, COBuilt 1981 · S/N P21000784 N6489WReed Michael · Temple, TXBuilt 1981 · S/N P21000785 N6527PKaci Property Management Inc · Boise, IDBuilt 1978 · S/N P21000186 N6531WInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N P21000791 N6537WSilver Eagle Holdings LLC · Jerome, IDS/N P21000793 N6542UMcdade John P · Fraser, COBuilt 1985 · S/N 21064957 N6582PGrand High Way LLC · Gallatin, TNBuilt 1978 · S/N P21000191 N6586WMair LLC · Lenexa, KSBuilt 1982 · S/N P21000800 N6593WSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N P21000801 N6598WValiair Lc Trustee · Casper, WYS/N P21000802 N6603UN6603u LLC · Albuquerque, NMS/N 21064959 N6609WKingsford Smith LLC · Tulsa, OKBuilt 1982 · S/N P21000804 N6634PAviation-Avsec Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1978 · S/N P21000194 N665SWAmerican Classic Corp · Ludington, MIBuilt 1980 · S/N P21000588 N666JGGronemeyer Jens · Deland, FLBuilt 1981 · S/N P210-00657 N66TEFly4fun LLC · El Segundo, CABuilt 1978 · S/N P21000154 N66VSEurovation Inc Trustee · KematenBuilt 1979 · S/N P21000421 N66WSDighans Murray · Peerless, MTBuilt 1979 · S/N P210-00363 N6700PAbraham Curtis · Byron, WYBuilt 1978 · S/N P21000200 N677PCTraven Ricardo Siro · Georgetown, SCS/N P21000677 N678CTSanborn Thomas W · College Station, TXBuilt 1978 · S/N P21000019 N67EPViner Kevin Patrick · Encinitas, CAS/N P21000032 N67JKInternational Air Services Inc Trustee · Carson City, NVS/N P21000684 N67VMCreeque Alley Ventures LLC · Missoula, MTBuilt 1980 · S/N P21000568 N67XLDavid E Morris Sr Enterprises LLC DBA · Mountainburg, ARBuilt 1983 · S/N P21000815 N68EAPav East LLC · Camden, DEBuilt 1985 · S/N P21000837 N6951YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N P210-00380 N6NTNevada Defense Group LLC · Henderson, NVBuilt 1978 · S/N P21000109 N700RSTransavia LLC · Wilmington, DEBuilt 1981 · S/N P21000716

Back to AD 85-11-07 R1