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.
N79390Grass Louis Humberto III · Hanford, CAN79391Scott William H · Mount Pleasant, SCN79393Frandsen Travis · Rexburg, IDN79395Cj Aviation LLC · Phoenix, AZN79397Scholl Aaron K · Abbeville, ALN79399Schneider Uwe · Port Orange, FLN7939GMilton Alvah E II · Surrency, GAN7939NOrama Jorge H · Fort Myers, FLN7939PHarper Hill Investments LLC · Independence, LAN7939WCaviation LLC · Columbus, NEN793AMeridian Aircraft LLC · Wilmington, DEN793CAChristiansen Aviation LLC · Wilmington, DEN793FAAb Prop Plane II LLC · Metairie, LAN793LLetourneau University · Longview, TXN793NDUnd Aerospace Foundation · Grand Forks, NDN793PTCappe Investment Group LLC · Homestead, FLN793SPLeading Edge Aviation Inc · Doylestown, PAN793YPark City Flight Training LLC · Merrill, WIN794U S Department Of The Interior · Boise, IDN7940EAircraft Guaranty Corp Trustee · Oklahoma City, OKN7940NCloudburst Resources Inc · Lavonia, GAN7940WMurray Air LLC · Patoka, ILN7940YN7940y LLC · Eagle Harbor, MIN79410N79410 LLC · Tupelo, MSN79412Talley William B · Bakersfield, MON79416Greene Tammy G · Alpharetta, GAN79417Lhotka Tim · Silver Lake, MNN79418Lee Steven W · Somerset, KYN7941GPressley Aviation LLC · New London, NCN7941HLugten John B · Walnut Creek, CAN7941NHonke Richard · Lake Andes, SDN7941PMcnew Johnnie Daniel · Paris, KYN7941WHansen Brandon C · Hyde Park, UTN79420Bas Part Sales LLC · Greeley, CON79421Kauer Roy A · Millington, MIN79428Mindset Dynamics LLC · Las Vegas, NVN79429Hinds Community College · Bolton, MSN7942GFlycarolina LLC · Rock Hill, SCN7942LSpitzer Jimmy J · Waxahachie, TXN7942YAtlantic Aero Marine Inc · Seaford, DEN79431Brown Joshua W · Pomona, ILN79432N7037g Inc · Wilmington, DEN79434Gilpin Jeffrey · Portland, ORN79435Pearce Gregory W · Eagle River, AKN79436Granskog Gary L · Chico, CAN7943PDavie Andrew S · Stony Point, NYN7943WBlue Ridge Aviation Services LLC · Ridgeway, VAN79440Spatiumtech LLC · Madison, ALN79442Friedmann David · San Diego, CAN79445Raniolo James · Jackson, WY
Back to AD 81-18-04 R2