Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N172RHMaya Air Services LLC · Lee, NHBuilt 2003 · S/N 172S9432 N172RJRidgik George H · Jamestown, COBuilt 1974 · S/N 17263314 N172RKEuros Aircraft Leasing LLC · College Station, TXBuilt 1999 · S/N 172S8082 N172RRFly Lugu LLC · Southwick, MABuilt 1973 · S/N 17261788 N172RSSchwartz Nathan S · Indianapolis, INBuilt 1961 · S/N 17248893 N172RVCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 2008 · S/N 172S10776 N172RWD Gordon Aviation Inc · La Jolla, CABuilt 1979 · S/N 17272209 N172SAHalbauer Peter · Hartford, WIBuilt 1969 · S/N 17258302 N172SBBirmingham Flight Center LLC · Birmingham, ALBuilt 1976 · S/N 17267683 N172SEIcebox Express LLC · Intl Falls, MNBuilt 2021 · S/N 172S12632 N172SFTichy Joseph R · Napa, CABuilt 1984 · S/N 172RG1149 N172SGLehner Raymond A Jr · North Fort Myers, FLBuilt 1973 · S/N 17261734 N172SJCommonwealth Of Massachusetts · Bridgewater, MABuilt 1997 · S/N 17280291 N172SKCruz Orlando R · Houston, TXBuilt 1978 · S/N 17271308 N172SNBukowski Robert · Hot Springs, ARBuilt 1969 · S/N 17258428 N172SRDiaz Robert Dorantes · Coalinga, CAS/N 17267952 N172SSWingsleasing LLC · Wichita, KSBuilt 1972 · S/N 17260696 N172STTextron Aviation Inc · Wichita, KSS/N 172S13635 N172SXPersonal Aviation Inc · Poway, CABuilt 1979 · S/N 17273641 N172SZPowell Terry · Sheridan, WYBuilt 1975 · S/N 17265508 N172TBBelli Paul · Philadelphia, TNBuilt 1970 · S/N 17259584 N172TCMeweber Consulting Inc · Atlanta, MIBuilt 1976 · S/N 17266662 N172TDSoule Clauson D · Cooperstown, NYBuilt 1970 · S/N 17258939 N172TGMaya Air Services LLC · Lee, NHBuilt 2002 · S/N 172S9126 N172THDairy Air Inc · Wyoming, PABuilt 1972 · S/N 17261033 N172TKRhinelander Flying Service Inc · Rhinelander, WIBuilt 1978 · S/N 17270406 N172TLRegistration Pending · Katy, TXRegistration pendingBuilt 1977 · S/N 17269706 N172TMTactical Integrated Training Solutions LLC · Colorado Springs, COS/N 17270278 N172TNRegistration Pending · San Antonio, TXRegistration pendingBuilt 1966 · S/N 17255519 N172TPContrail Aviation Inc · Cheboygan, MIBuilt 1956 · S/N 28401 N172TQAvolant Aviation LLC · Mooresville, NCBuilt 1998 · S/N 17280391 N172TRSkoglund David L · Jamul, CAS/N 17269899 N172TSVero Technical Support Inc · Pensacola, FLBuilt 1974 · S/N 17264582 N172TTErvin Max W · Bend, ORBuilt 1961 · S/N 17248370 N172TWGriffiths Larry F · Upland, CABuilt 1956 · S/N 29537 N172TXD & L Innovations LLC · Hendersonville, TNS/N 17271027 N172UCEndeavour Flight Training Inc · Opa Locka, FLBuilt 1978 · S/N 17271911 N172UFR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17273703 N172UZMp Aviation LLC · Ogden, UTBuilt 1980 · S/N 17274011 N172VFish Air Aviation LLC · San Diego, CABuilt 1985 · S/N 17276469 N172VFVictor Foxtrot LLC · Scott City, KSBuilt 1975 · S/N 17265334 N172VKKatula Gerard · Pawleys Island, SCBuilt 1968 · S/N 17257009 N172VLEnce Daniel G · Saint George, UTBuilt 1964 · S/N 17251968 N172VTFly Vermont LLC · Swanton, VTS/N 17263231 N172VWVanwagnen Brian J · Jackson, MIBuilt 1961 · S/N 17249058 N172VYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1963 · S/N 17250568 N172WLaraux Arthur · Bethel, AKBuilt 1971 · S/N 17260099 N172WAHandrop Ronald S · Bonita, CABuilt 1979 · S/N 17273507 N172WBTumbleweed Leasing Company Inc · Salt Lake City, UTBuilt 1978 · S/N 17270907 N172WEEl Aero Services LLC · Elko, NVBuilt 1975 · S/N 17265192

Back to AD 90-06-03 R1