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.
N6605PHillsboro Aero Academy LLC · Hillsboro, ORN6605RRegistered aircraftN6605UFoster Henry R · Saint George, SCN6605WChadwick Joseph G · Fayetteville, GAN66068Phoenix East Aviation LLC · Daytona Beach, FLN6606DRegistration Pending · Sturgeon Bay, WIRegistration pendingN6606FWestfall William L · Sunbury, OHN6606JSale Reported · Warner Robins, GASale reported, canceledN6606WMobley Ray M Jr · Midlothian, TXN66070Obetz Robert S · Manheim, PAN6607LGll Plane LLC · Ocala, FLN6607PHaumesser Daniel T · Kenosha, WIN6607UN6607u LLC · Commerce City, CON66083Bravo Zulu Aviation LLC · Torrance, CAN66084Cummings Steven R Trustee · Wyarno, WYN66085Bellers Aviation Inc · Fremont, CAN6608BTucker William C · Phoenix, AZN6608DAmericus Flying Club Inc · Americus, GAN6608JGreat Lakes Aviation Services Inc · Kimball, MIN6608RBogovich Robert E · Clifton, TXN6608URb II LLC · Walker, MNN6608WGrant Hooks LLC · Middleburg, FLN66090Skyline Solutions Inc · Deland, FLN66091Ftg Leasing LLC · Watkins, CON66097Gaskin Greg · Lake Almanor, CAN6609EClark Andrew M · Bend, ORN6609LUsda Aphis Ws · Cedar City, UTN660AAFms Bank · Fort Morgan, CON660BBKeys Vacation Rentals LLC · Palm City, FLN660CMJj Aviation LLC · Saint Peters, MON660DBAnderson Samuel D · Marana, AZN660EREmbry-Riddle Aeronautical University Inc · Prescott, AZN660FTFlorida Institute Of Technology Inc · Melbourne, FLN660HBJames Dennis A · Fort Valley, GAN660JWLearning 2 Fly LLC · Cave Creek, AZN660PCObrien Kenneth J · Lafayette, CON660RVMcclelland Dustin J · Reno, NVN660RWHay Johnny L · Bethel, OHN660SPRobert Devers Solutions · Hermosa Beach, CAN660SRAom Aircraft LLC · Orlando, FLN660TJmta Management LLC · Clinton, MON660TAReinhardt Anthony C · Duchesne, UTN660TMPeacock Quarry L · Post Falls, IDN6610Seyour Lori L · Woodstock, GAN66104Rhb Aviation LLC · New Orleans, LAN6610JSaracoff Norman L · Neillsville, WIN6610PBarr Merlin A · Clarinda, IAN6610UTreichler Peter DBA · East Aurora, NYN6610WHattersley Donald C · York, SCN66111Cutlass 661 LLC · Orange Park, FL
Back to AD 81-18-04 R2