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.
N8234FJones Christopher · Bonaire, GAN8234JCannoles Ronald · Las Vegas, NVN8234PMartinez Carlos M · Stafford, VAN8234VInnoutaero LLC · Stockton, CAN8234WRegistered aircraftN8234YBurkey Jeffrey C · Stuart, FLN82351Stasak Michael P Trustee · Sterling, AKN82353Billingsley Lowe J · Absarokee, MTN82358Nj Zev LLC · Morristown, NJN8235AEdgar E Herbert · Bowerston, OHN8235CBillmeyer Jim · White Salmon, WAN8235FPage John · Stockbridge, GAN8235PZiesman Ernest D · Henderson, NVN8235SWestern New York Flying Club · Bowmansville, NYN8235YLyons Kenneth L · Port Neches, TXN82368Williams Frank · Kerrville, TXN8236GVinton Timothy R · Whitman, NEN8236N8asplanes LLC · Lewes, DEN8236PLeary Patrick W · Lewistown, MTN8236RBellanca LLC · Galena, KSN8236WWilson Kevin · Boise, IDN82371Texas Bar Triangle LLC Plane Series · Mason, TXN82372Johnson Curtis M · Somers, NYN82377Miller Kyle · Bullard, TXN8237BFlying 20 Club Inc · Newtown, CTN8237PNarveson Kristian · Pueblo West, CON8237WS & S Entertainment Inc · Louisville, KYN82388Stephens Grant A · Palmer, AKN8238DAviation Therapy LLC · Livingston, NJN8238NSilver Hawk Aviation LLC · Panora, IAN8238PByer Connor · Brenham, TXN8238THerbert Keith Nicholas · Selbyville, DEN8238WParish John I · New Braunfels, TXN82391Trester Boyd H · Sentinel Butte, NDN82398Irwin Jeffrey C · Poland, NYN8239ABland Jerry D · Lubbock, TXN8239NKattke Timothy J · Redfield, SDN8239P3so II LLC · Louisville, KYN8239VMitten Adventures LLC · West Bloomfield, MIN8239YMurray Coy L · Guntersville, ALN823BBCampbell Bruce A · Sammamish, WAN823BCGrounded No More Veteran Flight Lift LLC · Queen Creek, AZN823CWChristopher Welvaert · Eldridge, IAN823DKKeck Joseph · Bittmore Lake, NCN823EJObrien Jeffrey W · Prairie Grove, ARN823HRBlue Air Training Corp · Las Vegas, NVNon-citizen corporation, flight hours not reportedN823JWEllis Jeffrey Mark · Waikoloa, HIN823KSKansas State University Salina · Salina, KSN823LCBonafide LLC · Wilmington, DEN823MGFisher Wade J · Hearne, TX
Back to AD 87-10-06 R1