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.
N859Registered aircraftN8590VNichols Dean Emerson · Clearwater, FLN8590YNorthern Aviation LLC · Palmer, AKN8590ZSkyborne Airline Academy Inc · Vero Beach, FLN8591CSkyborne Airline Academy Inc · Vero Beach, FLN8591DConservative Three LLC · Taft, CAN8592DRussell Terrell G · Isola, MSN8592ERegistration Pending · Vero Beach, FLRegistration pendingN8592NSluder George L · Willard, NCN8592VWest Michigan Aviation Academy · Grand Rapids, MIN8593CPockrus Pat B · Mineral Wells, TXN8593DTravis Charles E · Fairbanks, AKN8593GPiper Aircraft Inc · Vero Beach, FLN8593VShoemaker John L · Arnold, MDN8593WFerrin Scott Ellis · Provo, UTN8593YNickajack North LLC · Ocala, FLN8594Campbell Jaret R · Watertown, SDN8594CNagia Omar Mohamed · Richmond, CAN8594EMehlbauer Robert B · Owensboro, KYN8594FPiper Aircraft Inc · Vero Beach, FLN8594NKosciusko Skipper N · West Cornwall, CTN8594VCosta James J · Tulare, CAN8594WAlpha Berachah Omega LLC · Sanibel, FLN8595DPiper Aircraft Inc · Vero Beach, FLN8595MMohle Darren · Carlsbad, CAN8595VAnacortes Associates LLC · Anacortes, WAN8595YKor Reese W · Piedmont, SDN8596NLsg Flying Services LLC · Sarasota, FLN8596WMcm Legacy Enterprise LLC · Olmsted Twp, OHN8596YLeap Aviation Inc · Wilmington, DEN8597DRwr Air Inc · Tol, AKN8597LCb Aerial Application LLC · Kirksville, MON8597VSitta Donald C · Farmington, NMN8597YTaylor Douglas S · Fairfield, CAN8598CFrenzel Robert P · Midlothian, TXN8598DBurkhart Verlus L · Fairmont, MNN8598YGulf Coast Aviation LLC · New Orleans, LAN8599NScott Lauren M · Lighthouse Point, FLN8599VObx Airplanes LLC · Manteo, NCN8599WHackett Dean · Lake City, FLN859CPN859cp LLC · Boynton Beach, FLN859DAb Prop Plane II LLC · Metairie, LAN859DCIsr Aviation LLC · Wilmington, DEN859JANational Aircraft Leasing · Greenville, DEN859JTRainier Flight Service LLC · Renton, WAN859MHHarrington Mark · West Milford, NJN859RAThree Green Inc · Wilmington, DEN859RKRisk Indemnification Professionals LLC · Anchorage, AKN859SCFf22 LLC · Scottsdale, AZN859SPJet Air Inc · Iowa City, IA
Back to AD 81-18-04 R2