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.
N992TCSierra Heli Partners LLC · Reno, NVN992TFFriendswood Aviation LLC · Friendswood, TXN992VTVermont Flight Academy · South Burlington, VTN992WWTss Flying Club Inc · Bethesda, MDN9930SGpm Flyers LLC · Colleyville, TXN9930UCoffield Grant E · Mars, PAN9931BLevin Lawrence W · Glencoe, ILFirst renewal noticeN9931EN9931e LLC · Phoenix, AZN9931QDexter Aero Club Inc · Stetson, MEN9931ULett John S · Elk Grove, CAN99329Tactical Integrated Training Soluctions LLC · San Antonio, TXN99338Civil Air Patrol Inc · Maxwell Afb, ALN9933UMullins Russell H · Lagrange, GAN9933WSantangelo Troy M · Akron, PAN99341Jlinn Aviation Inc · Quinlan, TXN99344Global Tours & Travel Services LLC · Davie, FLN99347Skywarrior Flight Training Inc · Pensacola, FLN9934DLetkeman John K · Seminole, TXN9934PSouthern Aircraft Consultancy Inc Trustee · Casper, WYN9934QDoupe Services LLC · Fort Myers, FLN9935DDavis Nigel L · Helena, MTN9935FKrahe Richard P · Willoughby, OHN9935VD & S Aviation LLC · Wilmington, DEN9936QHunt Richard M · Columbus, OHN9936USale Reported · Wailuku, HISale reported, pending cancellationN9936VLeading Edge Flight Academy LLC · Bend, ORN9936WBrown Thrasher Aero LLC · Midland, GAN99374Martin Douglas C · Boca Raton, FLN99377Barta Terry · Faribault, MNN9937DSky High Adventures LLC · Wilmington, DEN9937E7 And 7 LLC · Leon, IAN9937QFosmo Richard E · Eatonville, WAN9937YWoods Justin S · West Glacier, MTN9938DStrub Henry J Jr · Dillingham, AKN9938UBurton Kenneth G · Hebron, INN9938WBerger Alexander W · Richmond, VAN9938YSchneider Bros · Manning, NDN99396Flightline Air Service LLC · Pineville, LAN9939HVawter Russell R Trustee · Nampa, IDN9939UGlover Joseph · Defuniak Springs, FLN9939WHoward Dwight · Beverly Hills, FLN9939YGehrke Walter L · Willow Lake, SDN993CCSale Reported · Kasota, MNSale reported, pending cancellationN993CMClaypool James W · Hunts Point, WAN993DBBauer Dereck R · Springfield, ORN993DCCoulter Daniel J · Mooresville, NCN993DGGardner David M · Rocklin, CAN993FAKjerstad Rodney R · Phoenix, AZN993FGFlightgest Academy LLC · Morrisville, NCN993HRObxpress LLC · Frisco, NC
Back to AD 87-10-06 R1