AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-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:87-10-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:87-10-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:87-10-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.
N9574BHinds Community College · Bolton, MSN9574HJb III LLC · Stuart, FLN9574LRiederich John B · Huntington Beach, CAN9574SKrejchik Daniel J · Portage, WIN9575DLaird Cristina R · Fairbanks, AKN9575JJones Anthony J · North Royalton, OHN9575UBarnett Gary L · Bertram, TXN9575VFurnari Alfio · Hutchinson Island, FLN9575WMike Flying Service LLC · Terrell, TXN9576Roznick John A · Stillwater, MNN9576CMercer Paul A · Salida, CAN9576JWright Jason C · Thorntown, INN9576KClearwater Valley Aero Club Inc · Kamiah, IDN9576MRpm Commander Holdings Inc · Vero Beach, FLN9576PPhiladelphia Glider Council · Hilltown, PAN9577BRegistration Pending · Scottsdale, AZRegistration pendingN9577DBerry Matthew G · Creedmoor, NCN9577JBrown Dennis N · Bakersfield, CAN9577LSquire Barry H · Sarasota, FLN9577MStaton Jered · Rochester, MNN9577USoluserv LLC · Caldwell, TXN9577VMdr Flying Inc Trustee · Wilmington, DEN9577WIasco Flight Training Inc · Redding, CAN9577ZAtp Aircraft 4 LLC · Wilmington, DEN9578BHalseth Harald E · El Paso, TXN9578ENorton Tim C · Danville, VAN9578JDesbien Paul D · Texhoma, OKN9578LRegistration Pending · Hoover, ALRegistration pendingN9578POldenburg Scott J · Kasilof, AKN9578UScheutzow David P · Medina, OHN9579CVan Winkle Steven Russell · East Berlin, PAN9579DLee Gerald R · Glennallen, AKN9579JGarrity Richard R · Green Bay, WIN9579LJackson Richard B · Cambria, CAN9579UBoland Kelly A · Fort Worth, TXN9579VPlaisted Aviation LLC · Elk River, MNN957AAAmdahl Alan W Trustee · Sioux Falls, SDN957BHHiggins William J · Plymouth, MAN957DScott Crump Properties LLC · Jasper, ALN957DHEddy Stephen Michael · Benton, KSN957DJKim Sung Su · Upland, CAN957PDEverything Pitts LLC · Queen Creek, AZN957RVWilson Tyler J · Lynnwood, WAN957SSkymark Airlines · Sacramento, CARegistration revokedN957TSevern Valley Aviation Inc Trustee · Wilmington, DEN957TEConlon Kevin P · Lake Geneva, WIN957UMBecker Brian S · Portage, WIN957WALuy Wayman A · Weston, FLN957WBWelch Mark A · West Hartford, CTN9580JFrontier Adventure Flyers LLC · Colorado Springs, CO
Back to AD 87-10-06 R1