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.
N739FU9fu LLC · Anchorage, AKN739FYSanford Aircraft LLC · Winter Springs, FLN739FZSorbi Aviation Inc · El Cajon, CAN739GCSavage Dewey M · Newport Beach, CAN739GDMidwest Trucking Transport Inc · Willowbrook, ILN739GEAllnew Enterprises Inc · Scotch Plains, NJFirst renewal noticeN739GFDahl Peter · Webster, MNN739GGRaptor Aviation LLC · South Saint Paul, MNFirst renewal noticeN739GHGreer Stephen R · Rowlett, TXN739GQMelbourne Flight Training LLC · Melbourne, FLN739GSCke Aviation LLC · Marietta, GAN739GUKimrey Norman Harold · Springdale, ARN739GWAce Pdr LLC · Lewisville, TXN739GXMusic City Air LLC · Rogersville, ALN739GYRadecki Francis R · Carmichael, CAN739HCGc Aviation Services-1 LLC · Miamisburg, OHN739HDRoseland Dan E · Sonoma, CAN739HETakai Hiroyasu · San Jose, CAN739HHAbove And Beyond Aviation LLC · Austin, TXN739HKSouthwest Aeronautics Mathematics & Science Acad · Albuquerque, NMN739HPHawaii Pacific Aviation Inc · Kailua Kona, HIN739HSOrange County Flight Center Inc · Santa Ana, CAN739HX739hx LLC · Jackson, MIN739HZZrelak Patrick H · Apple Valley, CAN739JGrace Mollie B · Batesville, ARN739JBS O W Aviation LLC · Crystal River, FLN739JCMoontown Airport Inc · Brownsboro, ALN739JDBergstrom Aircraft Inc · Pasco, WAN739JEMountain South Aviation LLC · Telford, TNN739JFSagori Aviation LLC · Orlando, FLN739JGLfw Investments LLC · Hillsborough, NCN739JHEfinger John · Cresson, TXN739JROklahoma State University · Stillwater, OKN739JUGregg Flying Service Inc · Durango, CON739JWJuliet Whiskey LLC · Wilmington, DEN739KBBentley Michael P · Spofford, NHN739KFFive Two Investments LLC · Oconomowoc, WIN739KKN739kk LLC · Phoenix, AZN739KRPayne David · Maryville, TNN739KSPlane One LLC · Kokomo, INN739KYFlyright Aviation Inc · North Las Vegas, NVN739LBBandy Robert W · Ridgecrest, CAN739LCHall Kenneth C · Durham, NCN739LDDass Ronald L · Hutchinson, MNN739LJHadley Susan S · Hamilton, GAN739LKBrown Yorke J · Enfield, NHN739LMColeman Kyle M · Sisters, ORN739LSBenham Properties LLC · Sullivan, INN739LTBlue Sky Flight Training LLC · Hamilton, OHN739LUBergstrom Aircraft Inc · Pasco, WA
Back to AD 87-10-06 R1