AD 90-04-06 R1
Registered aircraft · 68,377
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
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-04-06-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-04-06-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-04-06-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-04-06-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.
N822ESouthern Aircraft Consultancy Inc Trustee · Casper, WYN822GCareer Pilot Training LLC · Wilmington, DEN822GBBrown Thomas D · Griffin, GAN822GCHigh Mark C · Tooele, UTN822JSN822js LLC · Norcross, GAN822KTJet Air Inc · Iowa City, IAN822MLMojo Flight Group LLC · Gainesville, GAN822MWPilie Louis J · Grand Island, NYN822NDUnd Aerospace Foundation · Grand Forks, NDN822PASkywest Leasing Inc · St George, UTN822PJNeary Michael John · Tuckerton, NJN822REEaton Ray · Zeeland, MIN822RVWinningham Matthew P · Prattville, ALN822SPMcarthy Carolyn M · Chatham, MAFirst renewal noticeN822TFAir Fleet Holdings LLC · Missoula, MTN822VAffection Above Aviation Inc · Yukon, OKN822WSWallace State Community College · Hanceville, ALN822WYYoung James · Chehalis, WAN822XSpickard Mark A · Carr, CON8230EKnies Eugene W · Lebanon, TNN82318Aero Nautical Adventure LLC · Camano Island, WAN8231AKatsaliros Pete · Jackson, TNN8231EArctic Backcountry Flying Service LLC · Kotzebue, AKN8231GRad Pouria · Camarillo, CAN8231QAvier LLC · Beverly, MAN8231SBrown Mark · Peoria, ILN82325Hutchison John · Wasilla, AKN8232CLewis M Wayne · Chandler, AZN8232NWithee Steven A · Batavia, NYN8232WR&E Stars LLC · Fairfax Station, VAN82332Euroair Consultants LLC · Vero Beach, FLN8233CAirquest Aviation Inc · Kentwood, MIN8233TEast Bay Aviators N8233t · Kalispell, MTN8233WWhelchel Denise B · Upland, CAN8233XHarris Rand F · Camas, WAN82346Ross Douglas · Front Royal, VAN8234AKt Flight LLC · California, MDN8234CNewey John M Trustee · Cameron Park, CAN8234DPiper 34d LLC · Danvers, MAN8234FJones Christopher · Bonaire, GAN8234PMartinez Carlos M · Stafford, VAN8234VInnoutaero LLC · Stockton, CAN8234WRegistered aircraftN8234YBurkey Jeffrey C · Stuart, FLN82351Stasak Michael P Trustee · Sterling, AKN82353Billingsley Lowe J · Absarokee, MTN8235CBillmeyer Jim · White Salmon, WAN8235FPage John · Stockbridge, GAN8235GSterling Colleen M Trustee · El Cajon, CAN8235SWestern New York Flying Club · Bowmansville, NY
Back to AD 90-04-06 R1