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.
N7119VMark Youngblood Pa · Naples, FLN7119YFlydunn.Com Inc · Jacksonville, FLN711ABL J S Enterprises Inc · Albany, TXN711APStrzelski Edward · Perkasie, PAN711AVAa Aero Inc · Fairfield, NJN711AZGriffith Grading Co Inc · Newnan, GAN711BAPresley Louis · Cresson, TXN711BCSummit Air One Inc · Wilmington, DEN711BDCoburn Eric E · Leesburg, INN711BWQualitair LLC Trustee · MichelstadtN711CAZuber Robert W · Culver, ORN711CHYoung Vernon P · Metter, GAN711CKStecker Tyler J · Spokane, WAN711CVSmtm Holdings Inc · Wilmington, DEN711CZRutan Aircraft Flying Experience · Brookshire, TXN711DFFly Mooney LLC · Phoenix, AZN711DLPalm Beach Flight Training Corp · Lantana, FLN711DQNtx Citabria LLC · Wichita Falls, TXN711DTMcclellion W Richard · Anderson, SCN711EEBrunson Douglas H · Burnet, TXN711EMBlue Sky Jet Services LLC · Lititz, PAN711EUSuperior Rents & Sales Inc · Springfield, MON711EWWard Lumber Company Inc · El Cajon, CAN711EZSparrow International LLC · Littleton, CON711FLFernandez Kevin · Fuquay Varina, NCN711GTRadcliff Charles · Las Vegas, NVN711HYTegeler Walter S · Westminster, MDN711JGRv Guys LLC · Peachtree City, GAN711JJReady Aim Flyer LLC · New Castle, DEN711JLCentral Iowa Agricultural Aviation LLC · Wellsburg, IAN711KFJ-Com Aviation LLC · Richland, MSN711KKRegistered aircraftN711KNLowe Kevin · Martinsville, INN711LPJohnson Tommy A · Grand Junction, CON711LYSouthern Aircraft Consultancy Inc Trustee · Casper, WYN711NDFlight Leasing Corp · Wilmington, DEN711NECommander Flight Group LLC · Charlotte, NCN711PFTaylor Monty · Kingfisher, OKN711PKKramer Peter W · Copper Center, AKN711PTTaylor Stephen N · Punta Gorda, FLN711RNGoldsmith Donald E Jr · Brandywine, MDN711RPJwp Flying Services LLC · Chatfield, MNN711RVNicholson Kameran · Fowler, KSN711SFFlying L Aircraft Inc · Fort Denaud, FLN711SGGullo Santo · Ponce Inlet, FLN711SHHighley Robert W Jr · Lakeland, FLN711TANorth Star Equipment LLC · Simms, MTN711TSStarr William E · Eagle River, AKN711UATuthill Andrew M · Etna, NHN711WBNewberg Edgar T · Hector, MN
Back to AD 87-10-06 R1