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.
N817NDUniversity Of North Dakota · Grand Forks, NDN817TFAir Fleet Holdings LLC · Missoula, MTN817YLandon William Walton IV · Fairbanks, AKN817ZBennett Condon P · Stormville, NYN81809Corporation Of The Catholic Archbishop Of Anchorag · Anchorage, AKN8180CSnoopy Air LLC · Kalispell, MTN8180MLeap Aviation Inc · Wilmington, DEN8180WD And D Air Inc · Paola, KSN8180YG2g Aviation LLC · Wray, CON8181DMuleshoe Ranch Inc · Belle Fourche, SDN8181NBald Eagle Flying Club · South Portland, MEN8181XStelling William F · Fairbury, NEN8182BMorgan William J · Plano, TXN8182ERed Arrow Aviation LLC · Santa Teresa, NMN8182NJlf Air Inc · Evansville, INN8182WSwillen Richard Carl · Easley, SCN81830Wilkins Raymond E · Osceola, IAN8183CHendrie Derek · Venus, FLN8183DReabe Robert E · Waupun, WIN8183KSchleicher Richard A · Rch Palos Vrd, CAN8183NTucker Richard D · Locust, NCN81843Sorensen Paris K · Murrells Inlet, SCN8184CRouse Michael R · Wilson, NCN8184GAspire Aviation LLC · Farmingdale, NYN8184WBaker John L · Killen, ALN8185ARiggin William J · Carterville, ILN8185NWright Edward J Jr · San Antonio, TXN81866Wellness Flight LLC · Sarasota, FLN8186CKelliher Tia Marie · Eagle River, AKN8186KBlack Hills Soaring Club Inc · Rapid City, SDN8186NMorris Thomas L · Fairmont, WVN8186WStough Stephen A · Reno, NVN8186YHeiter Aviation Services LLC · Leesburg, INN81876Purcell Diane Diez · Baton Rouge, LAN81878Mcclave Wilkes III · Hanover, NHN8187DSchmidt Darrell · Kimberly, IDN8187HStover James L · Fredericksburg, VAN8187TLawdawg Property Rentals LLC · Williston, NDN8187WViroqua Area Flyers Inc · Viroqua, WIN8187XStevenson William E · Holton, KSN8187YWhite Jack S · Boone, NCFirst renewal noticeN81888Zion Thomas C · Middleboro, MAN8188CSlayden Steven M · Rhome, TXN8188PPurdy Bryan T · Bryant, ARN8188WBrewer Jordan L · Waynesboro, TNN8188YFly Anytime LLC · Kankakee, ILN81891Garnet Aviation LLC · Fort Worth, TXN81892Embry Kenneth · Nicholasville, KYN81894Yellow Dog Mgmt LLC · Fort Worth, TXN8189DWeese Chas K · Quinlan, TX
Back to AD 90-04-06 R1