AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N82EBBogner Edward R Trustee · Santa Cruz, CAN82EJJw Flyers LLC · Allen, TXN82EPPosav Holdings LLC · Zephyrhills, FLN82ERMidwest Airmotive Inc · Mount Sterling, KYN82EZFloyd Allen T · Erie, CON82FMF J Corporation · Wilmington, DEN82FYBurbage Richard W · Wichita Falls, TXN82GCVolk James E · Argyle, TXN82GHMorrison Richard L · Lake Como, FLN82HABeller Ronald D · Morehead, KYN82HUOpatril Ron · Creede, CON82HYJohnson Michael T · Moatsville, WVN82JStewart Michael W · Snellville, GAN82JDJ D Aviation LLC · Rochester, NYN82JNNicholas Kim A · Kent, WAN82KCDrake Raymond H · Asheville, NCN82KDKizita Management LLC · Los Altos, CAN82KLMcdaniel Michael Ray · Hampton Cove, ALN82KMShartle Austin W · Fredericksburg, PAN82KPCarter Doug A · Tower, MNN82LAAvery Lyle · Beach Lake, PAN82LECollier County Sheriffs Office · Naples, FLN82LMMartindale Harold L · Orange, TXN82LRKristoferson John S · Denton, TXN82LTRegistered aircraftN82MReady Aim Flyer LLC · New Castle, DEN82MHRainier Flight Service LLC · Renton, WAN82MTMalo Blake Ridgway Trustee · Portland, ORN82NBMohillsmith Coulter · Temecula, CAN82NDBaker David Jr · Louisville, KYN82NFN82nf LLC · Mckinney, TXN82PDJames Gary S · Weatherford, TXN82PLOilar Agricultural Services · Mcarthur, CAN82PMCollings 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, TXN82STStumpf Blain · Placerville, CAN82TDSharpe Andrew M · Wildwood, MON82THBirrell Christopher James · Ottumwa, IAN82TTJaconetti William J · Saint Peters, MON82VBSky Designs LLC · Kalamazoo, MIN82VWHeiman Caleb R · Summerfield, KSN82WGHash Brian Morrison · Mattawa, WAN82WHReed Joshua · Chesapeake, VAN82WKFarnum Kelly S · Midlothian, TX
Back to AD 81-18-04 R2