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.

N5073HElite Planes LLC · Menifee, CAS/N 17265331 N5073NPavco Inc · Gig Harbor, WABuilt 1985 · S/N 17276404 N50762Skyhawk Group · Kent, WABuilt 1974 · S/N 17264213 N5076NJb Aviation Flight School Inc · Wonder Lake, ILS/N 17265827 N50771Flying Mermaid LLC · Aiea, HIBuilt 1978 · S/N 17270862 N50772Donnelly Jennifer A · Hackettstown, NJBuilt 1971 · S/N 17259947 N5077APut Willem Albert · Birmingham, ALBuilt 1955 · S/N 28077 N5078ASmith Sidney R · Rllng Hls Est, CABuilt 1955 · S/N 28078 N5078RBlue Goose Aviation Inc · Polson, MTBuilt 1974 · S/N 17263316 N507DMChristiansen Aviation LLC · Wilmington, DEBuilt 2012 · S/N 172S11236 N507DROrtega Aviation Services LLC · Wichita, KSBuilt 2005 · S/N 172S9979 N507EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12858 N507LAColumbia Leasing LLC · Hillsboro, ORBuilt 2024 · S/N 172S13123 N5080ACoughlan Sally G · Bigfork, MTBuilt 1955 · S/N 28080 N5081AJones William H Trustee · Wenden, AZBuilt 1955 · S/N 28081 N5081UKiloecho Aeronautics LLC · Tucson, AZBuilt 1971 · S/N 17259673 N50822Nyhus Sharon L · Harvey, NDBuilt 1980 · S/N 17274221 N50826Bristol Bay Capital LLC · Watkins, COS/N 17274222 N5082AYoung Ryan E · Willis, TXBuilt 1955 · S/N 28082 N5082GJala Tech Services LLC · Social Circle, GABuilt 1979 · S/N 17273531 N5082RWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263320 N5082WAmeeti Robert Keith Trustee · Newport Beach, CABuilt 2001 · S/N 172S8970 N50838Ansee LLC · Seattle, WABuilt 1980 · S/N 17274224 N5083KLoewen Wielhelm N · Presidio, TXBuilt 1980 · S/N 17273956 N5084AOsterberg Douglas L · Neenah, WIBuilt 1955 · S/N 28084 N5084RBenham Eric T · Las Vegas, NVBuilt 1974 · S/N 17263322 N50858Christiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 172S10894 N5085KMartin Bach Aviation LLC · Cornelius, NCBuilt 1980 · S/N 17273957 N50864Rasmussen Agribusiness Inc · Antelope, MTS/N 17264215 N5086EPark David W · Placentia, CABuilt 1978 · S/N 17271703 N5086RSafety In Motion Flight Center Inc · Puyallup, WABuilt 1974 · S/N 17263324 N5087AMenard Bernny · Abbeville, LABuilt 1955 · S/N 28087 N5087EDern Aviation · Lake Charles, LAS/N 17271704 N5087JSession Jason E · Higden, ARS/N 17273698 N5087KAir Capital Aviators Club · Wichita, KSBuilt 1980 · S/N 17273958 N5088APieper Mike D · Chandler, OKS/N 28088 N5088KG & M Aircraft Inc · Wheat Ridge, COBuilt 1980 · S/N 17273959 N5088QMetro Aircraft Co · Bloomington, MNBuilt 2001 · S/N 172S8972 N5088RGlacier Equipment LLC · Wasilla, AKBuilt 1974 · S/N 17263326 N5089ABagley James R · Twentynine Palms, CABuilt 1955 · S/N 28089 N5089GFlywell Aviation LLC · Bowling Green, KYBuilt 1979 · S/N 17273538 N5089JWentzel Ron · Steamboat Springs, COBuilt 1979 · S/N 17273699 N5089RHigh Wing Air Services LLC · Merritt Island, FLBuilt 1974 · S/N 17263327 N508FGRidgeline Assets LLC · Wilmington, DEBuilt 2022 · S/N 172S12910 N508NDCorsair Aviation LLC · Pacoima, CABuilt 2010 · S/N 172S11061 N50906Aitken & Wilson Aviation LLC · Leesburg, VABuilt 1980 · S/N 17274232 N5090EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271705 N5091717 Leasing LLC · Englewood, COBuilt 1980 · S/N 17274233 N5091EAmerican Asset Leasing LLC · Aurora, ORBuilt 1978 · S/N 17271706 N5092AHansen Aviation LLC · Savannah, GABuilt 1955 · S/N 28092

Back to AD 90-06-03 R1