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.
N708JJacobsen Samuel J · Incline Village, NVN708JAYale Companies LLC · Fishers, INN708LAN708la LLC · Philadelphia, PAN708LSSchneider Larry E Trustee · Glendale, AZN708TSamples Kurtis K · Dallas, TXN708TEAileron Aviation Inc · Cookeville, TNN708TFAverett University · Danville, VAN708XEnsley Michael P · Colfax, WAN708YAltenbaumer Max Allen · Texarkana, TXN7090KUlibarri Christopher G · Abilene, TXN7090RMekolichick Jerry D · Whitehall, PAN7090WShipman Donald C · Interlochen, MIN7090YTucker Brandon · Rockledge, FLN7091GSkylark Flight Training LLC · Wilmington, DEN7091VFreimund Chandler R · Big Horn, WYN7092FBerger Jeremy L · Noble, ILN7092GAmick Thomas C · Newberry, SCN7092RCosey William Vester Franklin · Inverness, FLN7092VTextor William E · Springfield, MON7093BBackcountry Aviation LLC · Berthoud, COFirst renewal noticeN7093FPockrus Pat B · Mineral Wells, TXN7093GAero Performance LLC · Scooba, MSN7093KMoyers Tommy E · Portland, ARN7093RKearns Joseph E · Worthington, OHN7093YMoore James S Trustee · Gray Court, SCN7094DPotter Kent · Laurel, MTN7094GJohnson And Assoc · Davenport, IAN7094QRegistered aircraftN7094RWilson Flyers LLC · Rocky Mount, NCN7094VMason Gary W · Rockledge, FLN7095GHunter John Bockett · Riverton, NJN7095QWong Henry L III · Lake Forest, CAN7095RStevens Aircraft LLC · Morehead, KYN7095WByers Brady L · Newberg, ORN7096RHumphrey Richard K Jr · Abilene, TXN7096WN7096w LLC · Sherman Oaks, CAN7097GMurdy David C · Round Rock, TXN7097RFields Michael L · Rockwood, TNN7097WGlidepath Consulting LLC · Yuma, AZN7098KHensley Roger A · Rosamond, CAN7098WFarabee Mechanical Inc · Hickman, NEFirst renewal noticeN7099CAnderson Richard Alan · Brainerd, MNN7099GHunt Howard E · Martinsville, ILN7099KLach Richard · Weldon, CAN7099QVenaleck John T · Painesville, OHN7099YSparks Richard A · Wasilla, AKN709ABLohmann David P · Edwards, CON709BTAverett University · Danville, VAN709BWWolf Robert B · Boise, IDN709CAChristiansen Aviation LLC · Wilmington, DE
Back to AD 90-04-06 R1