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.
N7740WReiger Roger L · Lafayette, INN7741DJacko Josh E · Anchorage, AKN7741GCaviness Dewayne · Chico, CAN7741JPiper Mac 3 LLC · Dover, DEN7741NBrindle Richard L · Pleasant Hall, PAN7741ZNorth Florida Soaring Society Inc · Jacksonville, FLN7742JAirmore Inc · Gainesville, FLN7742MGribble Ted · Paris, TXN7742NDistler Robert · Northborough, MAN7742VNorbury Ross · Boonville, MON7742WDupont Micheal Rene · East Taunton, MAN7743DHann James M · Ballwin, MON7743MPatry Aeronautical Institute · Kalispell, MTN7743NRegistered aircraftN7743PWelch Brandon D · Liberty Hill, TXN7743WAtigun Aviation LLC · Sheridan, WYN7743YSchroeder David C · Norfolk, NEN7744MMike Clark Trucking Inc · Colton, CAN7744SVista Air Inc · Pacoima, CAN7744TDickert Investments Holdings LLC · Cave Creek, AZN7744WShotwell Michael · Dallas, GAN7744YCossette Aircraft LLC · Laporte, MNN7745DSale Reported · Joseph, ORSale reportedN7745GSuperhawk N7745g Owners' Group LLC · Bend, ORN7745MGsh Of Alabama LLC · Huntsville, ALN7745NAppealing Adventures Inc · Canadensis, PAN7745PFleming James D · Alamosa, CON7745WSchaff Investments LLC · Stone Mountain, GAN7746BMartin Gavin R · Los Angeles, CAN7746DDobson Garland J · Willow, AKN7746FWilliams Dwight J · Wichita, KSN7746PFlip Flops & Flight Plans LLC · Saint Petersburg, FLN7746YSnow Robert I · New Caney, TXN7747GKelley Aircraft LLC · Weyers Cave, VAN7747NShumock Jerry Ray · Moss Point, MSN7747PBartley John H · Vassalboro, MEN7747WFlying Family LLC · Orlando, FLN7747YBohannon Philip Wayne · Houston, TXN7748DJagust William M · Troy, MON7748JBas Part Sales LLC · Greeley, CON7748MLarson David · Klamath Falls, ORN7748PCardiovascular Service Associates · Downers Grove, ILN7749DOakley Lance E · Conway, ARN7749FLohr Martin J · Petersburg, AKN7749JKokomo Aviation Inc · Boynton Beach, FLN7749NTeijeiro Edgar E Trustee · El Paso, TXN774ACDarr Henry H · Drummond, MTN774CAChristiansen Aviation LLC · Wilmington, DEN774DSRosebud LLC · Libertyville, ILN774FSHilty Kenneth C · Greensboro, NC
Back to AD 87-10-06 R1