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.
N9466NWingert Douglas L · Smithfield, KYN9466PNewton Bros · Stratford, CAN9466WDisorbo Stephen S · New Milford, CTN9467CDominy Alan L · The Woodlands, TXN9467DHahn Randal N · Wasilla, AKN9467PRiver Aviation LLC · Wilmington, DEN9467WHartshorn Brian · Waynesville, OHN9468DKelly Henry Searles · Ossining, NYN9468FColeman Harold D · Pikeville, KYN9468HShouse Andrew · Flagstaff, AZN9468JSheffield Glenn A · Houston, TXN9468PSmall Alan J · Bristol, RIN9469DRanney Gayle · Cordova, AKN9469EParker Duane E · Louisville, KYN9469HAirplanes And Attitude LLC · Mckinney, TXN9469JNelson Stephen A · Milaca, MNN9469VNorton Curtis S Jr · Beaver Falls, PAN946BWhiteside William E · Talmage, CAN946BDBeede Curtis M Trustee · Maineville, OHN946BVAnton Bill · Satanta, KSN946CCBrown C C · Laramie, WYN946CHCritchfield Flying Service LLC · Rupert, IDN946CVLightcap Michael Wayne · Mc Alpin, FLN946DPDp Mirage LLC · Brentwood, TNN946GSStage George A · Kirtland, OHN946PMMorgensen John D · Prescott Valley, AZN946PTBrillo Benjamin G · Union City, CAN946SMEntrekin David C · Ridgeland, MSN946TEStrange Bird LLC · Hackensack, NJN9470DJacko Josh E · Anchorage, AKN9470WRegistration Pending · Cortez, CORegistration pendingN94714Wright Aero Inc · Saint Cloud, MNN9471CHitpas Henry R II · Beaufort, SCN9471DRasmuson Travis R · Helena, MTN9471PFly Yawa Aviation LLC · Statesboro, GAN9471VJ S Alguire Consulting Forestry Services Inc · Dover, DEN9471WMidway Enterprises Inc · Wilmington, DEN9472FJunell Sonny Brian · Midlothian, TXN9472HMulder Terry A · Appleton, WIN9472JMarquette County Flying Club · Marquette, MIN9472WSelvaraj Mylappan · Butler, PAN9473DZweifel Douglas L · Anchorage, AKN9473JEncounter Inc · Piedmont, OKN9473PSterling Commanche LLC · Kimberton, PAN9473VBarcus Roger L · Saint Paul, MNN9473WRohrer Stephen B · Decatur, GAN9473ZGoldstein Jeffrey Edward · Dix Hills, NYN9474BDiehl Greg · Angola, INN9474JGerber Dennis J · Liverpool, NYN9474NA-G-E Corp · Fort Pierre, SD
Back to AD 87-10-06 R1