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.
N95646Advantage Aviation Inc · Palo Alto, CAN9564CPowell David K · Edwardsville, ILN9564HLafleur Laurence J · Natick, MAN9564JIrvin Stephanie Michelle · Jacksonville, FLN9564MCheung Charlotte · San Jose, CAN9565Bailey Gordon J · Fayetteville, GAN9565JNebeker Kayla Rae · Murrieta, CAN9565MBitterroot Ventures LLC · Show Low, AZN9566BQualitair LLC · MichelstadtN9566DHerbert Brendan A · Portola, CAN9566HGarcia Mario · Yuma, AZN9566LNorth Sound Aviation · Sedro Woolley, WAN9566MRegistered aircraftAssigned, pending cancellationN9566VS D Enterprises Ltd · Brookhaven, NYN95670Board Of Trustees Of Southern Illinois Univ DBA · Murphysboro, ILN9567DFurois Alex D · Bridger, MTN9567HCurley Mark L · Alamosa, CON9567MArrowline Holdings LLC · Brookfield, CTN9567UBerka George · Wilmington, DEN9567VBdc Aero LLC · Miami, TXRegistration expired, pending cancellationN9567WMiler Aaron L · Chambersburg, PAN9568Medic Choppers LLC · Springdale, ARN9568CMitchell Stephen D · Wichita, KSN9568GTakai Hiroyasu · San Jose, CAN9568JJeep Kenneth M · Wadsworth, ILN9568LD & S Aviation LLC · Spring, TXN9568MKinney William A · Missouri City, TXN9568URegistration Pending · Bath, PARegistration pendingN9568VAnderson Zachery D · Bigfork, MTN9568WSale Reported · Cimarron, KSSale reportedN95690Daly Arthur P · El Paso, TXN9569FClassic Helicopter Corp · Auburn, WAN9569HOsborn Larry R · Summerville, SCN956CFHighwind Aero LLC · Inyokern, CAN956CPCivil Air Patrol · Maxwell Afb, ALN956DCLefthalfplane LLC · Kalispell, MTN956DSDelta State University · Cleveland, MSN956ERZulu Aircraft Leasing LLC · Grants Pass, ORN956ESHr Cabinets LLC · Nederland, TXN956GTTargonski Gregory · Williamson, GAN956JBJ Robb Consulting LLC · Scottsdale, AZN956JKKrips Jack E Jr · Winter Park, FLN956JWKms Investigations & Consulting LLC · Colleyville, TXN956LBStark Robert C · Hillsboro, ORN956MAAllen William D · Tampa, FLN956MDDigit Aviation LLC · Hampton, NHN956MTMiddle Tennessee State University Aerospace · Murfreesboro, TNN956PMSparks James D · Glennallen, AKN956RHHuston Ben E · Sanger, TXN956RVKemph Jeffrey A · Howell, MI
Back to AD 81-18-04 R2