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.
N82779Northeast Planes Aviation Inc · Laramie, WYN82783Gulf Atlantic Airways Inc · Gainesville, FLN8278EEquinoxx Flight Systems LLC · Lawrenceville, GAN8278HCedar Hill Aviation Service Llpc · Cedar Hill, TNN8278NBastian Richard D · Chiloquin, ORN8278PDewalt Rodney P · Fort Worth, TXN8278WChamberlain Mark S · Hamburg, NYN8278ZSaenger Lawrence · Mountain Home, IDN8279EHull Farms Inc · Blythe, CAN8279HChilhowee Soaring Association Inc · Benton, TNN8279JRowland Blayne C Administrator · Raymondville, TXN8279NWillson Michael S · Saint Cloud, FLN8279PRobinson Andrew T · South Windsor, CTN827ATAviation Training LLC · Wilmington, DEN827CTobin James M · Latrobe, PAN827CPCivil Air Patrol · Maxwell Afb, ALN827CYPitzer Cheryl · Nevada, TXN827ECPacific Fleet Aviation LLC · Rochester, NYN827EREmbry Riddle Aeronautical University · Daytona Beach, FLN827ESAtp Aircraft 1 LLC · Wilmington, DEN827FJMiller Andrew W · Palmer, AKN827FKSkyvibes LLC · Abingdon, VAN827GBJohnson Douglas C · North Grafton, MAN827GLEtchart Joseph O · Glasgow, MTN827GSFosha Kathryn · Tehachapi, CAN827JHEisenmenger James P Trustee · Yankton, SDN827JPHuls James J · Madison, SDN827KSPlanelease LLC · Venice, CAN827LBCapital Consulting LLC · Newport Beach, CAN827LSStone James Ellis · Knoxville, TNN827MAPs N827ma LLC · Green Bay, WIN827NDUnd Aerospace Foundation · Grand Forks, NDN827PAkin Thomas A · Visalia, CAN827PAJa Flight Services LLC · Sugar Grove, ILN827PMMagnuson Peter C · Ocala, FLN827RDGoyo Air LLC · Miami, FLN827SCSpitzer Helicopter LLC · Wilmington, DEN827SH1 Acadiana Helicopters Company LLC · Cade, LAN827VPClik Services LLC · Forestdale, MAN827WTCsu Aviation LLC · Plainfield, INN82808Hruby Bernadette · Baraboo, WIN8280NEllis Clifford J · Murray, KYN8280WGarbin Kurt A · Steamboat Springs, CON8281CThomas Ken C · Fairbanks, AKN8281EAir Plains Services Corp · Wellington, KSN8281GWidtfeldt John R · Auburn, PAN8281JJudy Gregory K · Hudson Oaks, TXN8281NTan Dexter E · Dallas, TXN8281PDubois Jean-Claude · Midlothian, TXN8281WNeisen Brandon L · Fowler, IL
Back to AD 81-18-04 R2