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.
N82FMF J Corporation · Wilmington, DEN82FWRemkes Wolfgang H J Trustee · Gilroy, CAN82FYBurbage Richard W · Wichita Falls, TXN82GCVolk James E · Argyle, TXN82GHMorrison Richard L · Lake Como, FLN82HABeller Ronald D · Morehead, KYN82HYJohnson Michael T · Moatsville, WVN82JStewart Michael W · Snellville, GAN82JNNicholas Kim A · Kent, WAN82KCDrake Raymond H · Asheville, NCN82KGBch Real Estate LLC · Eagle, IDN82KLMcdaniel Michael Ray · Hampton Cove, ALN82KMShartle Austin W · Fredericksburg, PAN82KPCarter Doug A · Tower, MNN82LAAvery Lyle · Beach Lake, PAN82LECollier County Sheriffs Office · Naples, FLN82LLSda Aviation LLC · Winnsboro, LAN82LRKristoferson John S · Denton, TXN82MReady Aim Flyer LLC · New Castle, DEN82MTMalo Blake Ridgway Trustee · Portland, ORN82NBMohillsmith Coulter · Temecula, CAN82NDBaker David Jr · Louisville, KYN82PMCollings Foundation Inc · Hudson, MAN82RRegistered aircraftN82RBBurns Robert A · Fort Myers, FLN82RCShackelford John S Jr · Roanoke, TXN82RDStrafford Cameron Cornell · San Diego, CAN82RHHolte Brian J · Monticello, MNN82RJLynch James D Jr · Ocala, FLN82RRCramp Steven J · Cleveland, TXN82THBirrell Christopher James · Ottumwa, IAN82TTJaconetti William J · Saint Peters, MON82VWHeiman Caleb R · Summerfield, KSN82WGHash Brian Morrison · Mattawa, WAN82WHReed Joshua · Chesapeake, VAN82WKFarnum Kelly S · Midlothian, TXN82WMBlackaby Kurt Allen · Bentonville, ARN82ZACullen David F · Lantana, FLN83003Bravo One LLC · Lewes, DEN83009Paris Air Inc · Vero Beach, FLN8300JHepper Abby · Keene, NDN8300RBodner Michael J · Rock Hill, SCN83013Tjmc LLC · Riverbank, CAN83016Maks97 LLC · Sparta, MIN8301CBeach Aero LLC · Virginia Beach, VAN8301FSorensen Daryl · Presque Isle, MIN8301PMann Herbert A · Soldotna, AKN8301RGotgumbo LLC · Cranberry Township, PAN8301W01w Aero LLC · Conway, ARN83021Kosbruk Boris R Jr · Perryville, AK
Back to AD 87-10-06 R1