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.
N7405XWills Terry W · Cedar Park, TXN7406PAviation Collective LLC · Fort Worth, TXN7406VEvans Steven M · Somis, CAN7406YTucker Engineering Associates Inc · Locust, NCN74079Marques David A · Gilbert, AZN7407FFp Aircraft Holdings LLC · Alvord, TXN7407WTevik Michael A · Provo, UTN74080Lowry John O · Willis, TXN74086Meyer Michael · San Diego, CAFirst renewal noticeN74088Mcgee Neil R · Littleton, NCN7408DTobin John C · Olympia, WAN7408JHiller Alex T · Lake Orion, MIN7408KCapps Steven · Newcastle, OKN7408RAdventures Aviation LLC · Whitehouse Station, NJN7408VM Twenty Inc · Bismarck, NDN74090Tiger Air LLC · Chatsworth, CAN74092Mcgill John G · Atlanta, GAN74094Eastern Shore Flying Service Inc · Wilmington, DEN74095Benson Edwin R · Gulfport, FLN74096Borden Lester N · Dalzell, ILN74099Sigg David · Bluffton, SCN7409DBartlett Donald R · Weirsdale, FLN7409GAero Quest LLC D/B/A · Olive Branch, MSN7409JAdp Consultants Inc · Laurel, MDN7409PPeters Gordon J · Salem, ORN740HSSnook Harold F · Beaver Springs, PAN740NDUnd Aerospace Foundation · Grand Forks, NDN740PASkywest Leasing Inc · St George, UTN740UOhio University · Albany, OHN740WTCentral Valley Flight School LLC · Hanford, CAN74100Derby Kent E · Denver, CON74101Mickelsen Brian C · South Jordan, UTN74104Supan J T Trustee · Santa Cruz, CAN74105Lamphier Marc S · Lawrence, MAN74109Piscitello Thomas J · Yulee, FLN7410DHampton Michael D · Marshfield, MOFirst renewal noticeN7410JGeorge Ladelle · Ashley, NDN7410RElon Aviation LLC · Burlington, NCN7410WKlassen Peter K · Seminole, TXN7410YDuncan Paul J · Bartlett, TNN7411BWilcox Stacy S · Parker, CON7411DMclain Joseph L · Louisville, KYN7411VDk Aero LLC · Wilmington, DEN74127Richards Michael W · Lafayette, INN7412JDubois Aviation Inc · Chino, CAN7412KBailis David P · Bethlehem, PAN7412RZembinski Robert A · Brookfield, WIN7412WRegistered aircraftRegistration pendingN7413DDraper Scott · Rutland, VTN7413JLittle Evin M · Bidwell, OH
Back to AD 90-04-06 R1