Skip to content

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.

N474TBDr Daniel Brancheau Pllc · Fenton, MIBuilt 1980 · S/N 172RG0238 N4751GJeff Air Pilot Services LLC · Shelbyville, INS/N 17273337 N4752RCondors Flight LLC · Orlando, FLS/N 172RG0023 N47559Valiair Lc Trustee · Casper, WYBuilt 1960 · S/N 47559 N4757DCalhoun Gerrald E · Leesburg, FLS/N 17272352 N4759GSanders Flight Training Center Inc · Jasper, ALS/N 17273341 N475EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12248 N4763DRandolph Terrence · Bowie, MDBuilt 1979 · S/N 17272354 N4764DQuadrelec Engineering Corp · Tulsa, OKBuilt 1979 · S/N 17272355 N47657Dallam Pat M · Cool, CABuilt 1979 · S/N 17271962 N4768EEagle Aviation Inc · Tucson, AZBuilt 1978 · S/N 17271633 N476CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2015 · S/N 172S11621 N476DTTallarita Domenic A · Palm Springs, CAS/N 17254299 N476EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12249 N476SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280621 N4772EDrost Larry L · Charlevoix, MIBuilt 1978 · S/N 17271637 N4772RKimball Michael G · Placerville, COBuilt 1979 · S/N 172RG0027 N4774EZhao Dan · New York, NYBuilt 1978 · S/N 17271639 N4774FIlmberger Stephen J · Bend, ORBuilt 1979 · S/N 17273079 N4775DHetrick-Price Willow · Anchorage, AKBuilt 1979 · S/N 17272357 N4776EAlpha One Aviation LLC · Dunedin, FLBuilt 1978 · S/N 17271641 N4778EClemmons Flyers LLC · Green Cove Springs, FLS/N 17271643 N477EE477ee LLC · Bethany, OKBuilt 2023 · S/N 172S12954 N477FReu Aviation LLC · Columbia, SCS/N 17265266 N4780ECarolinas Aviation LLC · North Myrtle Beach, SCBuilt 1978 · S/N 17271645 N4782RSchulert Peter A · Lebanon, TNBuilt 1979 · S/N 172RG0030 N4784EPeabody Jeffery L · Vinemont, ALBuilt 1978 · S/N 17271649 N4786ETu Erik S · Pasadena, CABuilt 1978 · S/N 17271651 N4787ESilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1978 · S/N 17271652 N4788DJb Aviation Flight School Inc · Wonder Lake, ILBuilt 1979 · S/N 17272359 N4788ETiernan Jeffery P · Waddington, NYBuilt 1978 · S/N 17271653 N4788VM Fujii Inc · Costa Mesa, CABuilt 1980 · S/N 172RG0378 N4789DStevens Dennis W · Mohave Valley, AZBuilt 1979 · S/N 17272360 N4789EPhil Weber Investments LLC · San Diego, CABuilt 1978 · S/N 17271654 N4789GCrossflot Aviation Inc · Shepherdstown, WVBuilt 1979 · S/N 17273343 N478CAWingsleasing LLC · Wichita, KSS/N 172S11740 N478CMUniversity Fo Central Missouri · Warrensburg, MOBuilt 2011 · S/N 172S11143 N478KBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 2023 · S/N 172S12966 N478SPAbove And Beyond Aviation LLC · Austin, TXBuilt 1998 · S/N 172S8023 N478TWTumbleweed Leasing Company Inc · Salt Lake City, UTS/N 17265231 N4790EMahon Enterprises LLC · Gray Court, SCBuilt 1979 · S/N 17271655 N4790GWings Over Texas Holdings LLC · Denton, TXS/N 17273344 N4790JAmanzi LLC · Brasstown, NCFirst renewal noticeBuilt 1979 · S/N 17273677 N4791EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271656 N4791VAmerican Eagle Realestate & Financing Corp · Royal Palm Beach, FLBuilt 1980 · S/N 172RG0379 N4793EKillpack Kevin R · Rio Rancho, NMBuilt 1978 · S/N 17271658 N4793FCitizen Air LLC · Port Angeles, WABuilt 1980 · S/N 17273081 N4796VPittman Robert · Ocala, FLBuilt 1980 · S/N 172RG0381 N4798EClark Robert · Junction City, KSBuilt 1978 · S/N 17271663 N479CNFlight World Inc · San Juan, PRBuilt 1975 · S/N 17266007

Back to AD 90-06-03 R1