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.

N2810UN2810u LLC · Delray Beach, FLBuilt 1963 · S/N 17250410 N2812LHarris Partnership · Conway, ARBuilt 1967 · S/N 17256012 N2812QHammond David J · Chesterfield, VABuilt 1971 · S/N 17259812 N2812UBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 17250412 N2813LFoster Neal W · Nome, AKBuilt 1967 · S/N 17256013 N2813QOriginal Design Ministries · Eatonville, WABuilt 1971 · S/N 17259813 N2814LStewarts Aircraft Service Inc · Waynesville, OHBuilt 1967 · S/N 17256014 N2815UHarris Tony James · Stanley, NCBuilt 1963 · S/N 17250415 N2817UAero Ventures Inc · Yukon, OKBuilt 1963 · S/N 17250417 N2818DSlodki David · Massapequa Park, NYBuilt 1978 · S/N 17270704 N2818ESale Reported · Lexington, NCSale reportedBuilt 1978 · S/N 17271334 N2818UWard Jasper Eugene · Telford, TNFirst renewal noticeS/N 17250418 N2819QAirborne LLC · Wilmington, DEBuilt 1971 · S/N 17259819 N2819UGartner Thomas M · Newton, KSBuilt 1963 · S/N 17250419 N281EAElevation Air Capital LLC · Janesville, WIBuilt 2023 · S/N 172S13043 N281PEBravo Leasing LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10878 N2820LHarrington Thomas W Jr · Cumming, GAS/N 17256020 N2820QBush Steven B · Lago Vista, TXBuilt 1971 · S/N 17259820 N2821UPelotte Raymond J · Waterville, MEBuilt 1963 · S/N 17250421 N2822LRobertson IV Henry B · Owensboro, KYS/N 17256022 N2823E2lyons Enterprises LLC · Westlake, FLBuilt 1978 · S/N 17271335 N2823UPowell Mark J · Chelsea, MIBuilt 1963 · S/N 17250423 N2824QAv8 LLC · Davenport, IAS/N 17259824 N2826LJamtori Investments LLC · Forrest City, ARS/N 17256026 N2826QMcmillan Roger L · Camdenton, MOBuilt 1971 · S/N 17259826 N2826UJohnson James E · College Station, TXBuilt 1963 · S/N 17250426 N2828QJack Dixon · Haiku, HIBuilt 1971 · S/N 17259828 N2829EEverts Air Service Inc · Sarasota, FLBuilt 1978 · S/N 17271336 N2829LGeaux Fly LLC · Bossier City, LAS/N 17256029 N2829QL & L Aviation LLC · Sidney, NEBuilt 1971 · S/N 17259829 N282MEJet Air Inc · Iowa City, IABuilt 2000 · S/N 172S8540 N282MMMewmew Investment II LLC · Palo Alto, CABuilt 2019 · S/N 172S12247 N282PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10750 N2830LPilotpros Training LLC · Longview, TXBuilt 1967 · S/N 17256030 N2830PSandpiper Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280593 N2830QRetro Modern Aviation LLC · Manitou Springs, COBuilt 1971 · S/N 17259830 N2831LJkj Flying LLC · Chittenango, NYBuilt 1967 · S/N 17256031 N2831USchmidt Paul D · Whitesburg, GABuilt 1963 · S/N 17250431 N2832URegistration Pending · Wasilla, AKRegistration pendingS/N 17250432 N2833LWade Kenneth L · Huron, TNBuilt 1967 · S/N 17256033 N2834LRomano Kenneth J · Shirley, NYBuilt 1967 · S/N 17256034 N2834QHarford Flying Club Inc · Kingsville, MDBuilt 1971 · S/N 17259834 N2835LBrinkmac LLC · Cadillac, MIS/N 17256035 N2835QSan Fernando Aviation LLC · Van Nuys, CABuilt 1971 · S/N 17259835 N2836LRyan Patrick J · Quinton, VABuilt 1967 · S/N 17256036 N2836USolymanbeyk Willard · Modesto, CABuilt 1963 · S/N 17250436 N2837LGehrke Halle · Elk Mound, WIBuilt 1967 · S/N 17256037 N2837QChaffee Dean L · Weidman, MIBuilt 1971 · S/N 17259837 N2838LA-R-M Aircraft Leasing LLC · Williamsburg, VABuilt 1967 · S/N 17256038 N2838QAdriatic Holdings LLC · Cheyenne, WYBuilt 1971 · S/N 17259838

Back to AD 90-06-03 R1