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.
N9889WFaix James M · Sarasota, FLN988AMM & G Aircraft Management LLC · Englewood, CON988BBForbes Donald L · Central Point, ORN988BGMojo Flight Group LLC · Gainesville, GAN988BSJonsson Erik R · Twin Falls, IDN988CPCivil Air Patrol Inc · Maxwell Afb, ALN988DDSchumacher Christopher R · Destin, FLN988GAtp Aircraft 9 LLC · Wilmington, DEN988GTGallagher Daivd A · Nashville, TNN988JBBard John A · Mount Vernon, WAN988JFMcdaniel Patrick D · State College, PAN988MLLong Mark Allen · Stanton, MIN988MSLong Mark A · Stanton, MIN988NPlane Fun Inc Tr Trustee · Snellville, GAN988NADion William J · Coupeville, WAN988RAFifteen-Sixty LLC · Ottawa Hills, OHN988RBAslesen Leasin LLC · Halstad, MNN988TCSpaulding Bernard B · Terrell, TXN988TPOdendahl Thomas H Jr · Saint Augustine, FLN988TSFerrand Kathy · Cornelia, GAN988TWPonderosa Farms LLC · Scarsdale, NYN988UPKame Steven H · Roseburg, ORN988WUBravo Whiskey Aviation LLC · Louisville, KYN98901Haley Lawrence E II · Naples, FLN9890KWilliams Robert · Dawsonville, GAN9890WKoryciak Robert L · Boling, TXN98910Wikle Artic C · Wasilla, AKN98913Civil Air Patrol Inc · Maxwell Afb, ALN9891GOuellette Kevin E · Frederick, OKN98923Costa Flying Service Inc · Painted Post, NYN9892GFritz John P · Belvidere, NJN9892PArizona Soaring Inc · Maricopa, AZN9892QLytle Jack J · Omaha, NEN9892YWraith Daniel T · Wasilla, AKN9893QDougherty Casey · Rock Island, WAN9893WSky High Aviation LLC · Streamwood, ILN9894G1s6 Flying Club Inc · Sandpoint, IDN9894QKarpov Konstantin A Trustee · Fort Bragg, CAN98954Emerson Solutions LLC · Bellingham, WAN9895GKellerman Roger B · Rockford, ILN9895QCk Leasing Services LLC · Wilmington, DEN9895VTogo Aviation Services LLC · Palmer, AKN9896Paul Chappano Pa · Saint Johns, FLN98960Buiqui Aerospace Corp · Kissimmee, FLN9896PLees Aerial Spraying Inc · Aberdeen, IDN9896UAmaya Ricardo · Shelby, NCN9896WKnapp Joseph E Jr · Clermont, FLN9896YFrisby James A · Palmer, AKN9897DRobinson Scot K · Powderville, MTN9897PMississippi State University Soaring Club Inc · Mississippi State, MS
Back to AD 87-10-06 R1