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.
N6999BGochenour Tim B · Macy, INN6999DN6999d LLC · Fairfax, VAN6999JSun West Aviation Inc · Santa Ynez, CAN6999KHalpin William J · Eden Prairie, MNN6999QBas Part Sales LLC · Greeley, CON6999URuff Daniel D · Yacolt, WAN6999VBredthauer Glen E · Hastings, NEN6999WSilva Javier · Sanger, TXN699BMunn Kenneth D · Zephyr Cove, NVN699CBBig Skylands Aviation LLC · Succasunna, NJN699DKN699dk LLC · Caledonia, MIN699DMBarber Christopher A · Toney, ALN699DSNimer David K · Malad City, IDN699DWDw Flight LLC · Columbus, OHN699FLEdgewood Acres LLC · Willmar, MNN699JBBaker James W · Goodland, KSN699LCAero Management LLC · Austin, TXN699LGN699 Lg LLC · Mahtomedi, MNN699LHFf22 LLC · Scottsdale, AZN699MDJvation LLC · Belgrade, MTN699MSSouthern Aircraft Consultancy Inc Trustee · Casper, WYN699RBMaoz Eyal Trustee · New York, NYN699RVHughes Adrian P · Everett, WAN699SPMa Aviation LLC · Danville, ILN699TBUS Anesthesia Consultants LLC · Chesterfield, MON699WSeabourn Scott R · Newberg, ORN699WPHilke Robert J · Carson City, NVN699ZMichfab Machinery Inc · Grand Rapids, MIN69AJKolea Leasing LLC · Honolulu, HIN69APScott Brady · Manakin-Sabot, VAN69AUThoma George E · Old Lyme, CTN69BLykins Matthew · Stevensville, MTN69BCStephen Korney · Norwalk, CAN69BNSky West Aviation Inc Trustee · Albuquerque, NMN69CNTachoir Steven E · Marienville, PAN69CPBuena Vista Hunting LLC · Eagle Pass, TXN69CZVermeylen John B · Altamont, TNN69DLIndy Air Sales LLC · Anderson, INN69DSSale Reported · Tomball, TXSale reportedN69DYJohnson Christopher · Tulsa, OKN69ETSale Reported · Nampa, IDSale reported, pending cancellationN69FLFlx Holding Co LLC · Boca Raton, FLN69FMAirtime LLC · South Lyon, MIN69GSDaphnee Moise Md Pa · Sarasota, FLN69HANorth County Flying LLC · North Palm Beach, FLN69HHTaylor Kent M · Crawford, COFirst renewal noticeN69JBIsburgh Andrew N · Conyers, GAN69JDPrivate Aero LLC · Sarasota, FLN69JTGranger Daphne · Pearland, TXN69JVRasch Hellmut G · Tomball, TX
Back to AD 87-10-06 R1