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.
N7938MSanders David D · Alvin, TXN7938PWardly George A · Ridgewood, NJN7938WPiper Club LLC · Atkinson, NEN7938YEai Aircraft LLC · Fairbury, NEN79390Grass 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, DEN793NDUnd Aerospace Foundation · Grand Forks, NDN793PTCappe Investment Group LLC · Homestead, FLN793SPLeading Edge Aviation Inc · Doylestown, PAN793YPark City Flight Training LLC · Merrill, WIN7940EAircraft 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, NCN7941NHonke 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, MSN7942CN4143w LLC · Los Gatos, CAN7942GFlycarolina 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, CA
Back to AD 87-10-06 R1