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.
N8620CLrh Equipment LLC · Pendleton, ORN8620DMid Atlantic Air Museum · Reading, PAN8620WPurcell Holdings Lc · Tremonton, UTN8621DBrown Lonnie S · Lone Jack, MON8621EUpdraft Leasing LLC · Tea, SDN8621NMcdonald Timothy Shane · Saint Jacob, ILN8621YParks Ashton · Pepperell, MAN8622DGrass Strip Life LLC · Gulf Breeze, FLN8622EChapin Ray DBA · Geneva, NYN8622NPapp Adam P · Raleigh, NCN8622UMiller Mark E · Willow, AKN8622VHoneycutt Aviation Inc · Olivehurst, CAN8622WMoody Robert F · Salinas, CAN8622XNorthern Construction Inc · Haines, AKN8622YClosson Luke E Jr · Valdosta, GAN86238Crawford Thomas P · Elgin, ILN86239Lrh Equipment LLC · Pendleton, ORN8623EBeach Pilot LLC · Winchester, VAN8623PMajor Development LLC · Cedaredge, CON8623TAmerican Adventure Dreams LLC · Dover, DEN8623WNeville Scott A · Phoenix, AZN86243Miller Mark · Willow, AKN86244Burke Clint H · Olympia, WAN8624BSummit Peak Holdings LLC · Missoula, MTN8624GTemair LLC · San Francisco, CAN8624QRuckle Kelby J · Whittemore, MIN8624VMccoard Paul · Provo, UTN8624YRegistered aircraftN8625DMyers Martin John Trustee · Juneau, AKN8625KRotor F28f LLC · Lake City, FLN8625NJanicke Clayton R · Bird City, KSN8625VLemaire Jonathan D · Taunton, MAN8625WLuke Jahn A · Englewood, OHN8625ZMacarthur Gerald · Hillman, MIN8626ASouth County Helicopter LLC · Pilot Rock, ORN8626NCf Aviation LLC · Wellington, FLN8626PMussche Roger H · Lafayette, INN8626SSkorecki Ryan A · Girdwood, AKN8626VAlaska Star Flying Club LLC · Wasilla, AKN8626WBoies Ryan Nicholas · Auburn, MEN8626YThomas William R · Rochester, MNN8627LSouthern Cub & Aircraft Restoration LLC · Pensacola, FLN8627PRegistered aircraftN8627VDunleavy John R · Mandeville, LAN8627WNash Kim A · Billings, MTN8628UTownsend Slade · Fredonia, TXN8629DLogan Todd S · Bucyrus, OHN8629LKnutson Wayne R · Thompson, NDN8629NN8629n Inc · Ooltewah, TNN8629WKowalewski Dennis R · Mesquite, NV
Back to AD 87-10-06 R1