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.
N8980YTomu Fly LLC · Vero Beach, FLN89811Sky Warrior Flight Training Inc · Pensacola, FLN89812Fremont Aviation Inc · Fremont, NEN89815Pinnacle Aviation Services Inc · Encinitas, CAN8981AAmerican Aircraft Sales LLC · Lincolnshire, ILN8981RBlock Raymond J · Palmer, AKN8981YGrey Enterprises Holdings LLC · Kalispell, MTN8982DNorth Sound Aviation Inc · Sedro Woolley, WAN8982RBoo Steven R · Chisago City, MNN8982VHirsch John K Trustee · Gerald, MON8982WTorres Lewis A · Pasadena, CAN8982YCovington James P · Poplar Grove, ILN8983JStensrud Maynard R · Waseca, MNN8983LSale Reported · Austin, TXSale reportedN8983PBlum Kenneth J · Truckee, CAN8983VMoon Reagan E · Bossier City, LAN8984CBaldwin Alexander L · Saint Charles, MON8984JKlassen Wayne V · New Ulm, MNN89859Hess Garrett J · Fullerton, CAN8985WKeskintepe Levent · Las Vegas, NVN89863Ruess Richard M · Anchorage, AKN89869Wings Over Texas Holdings LLC · Denton, TXN8986JKleinberg Kenneth A · Saugerties, NYN8986LHenrichs Jason · Pearland, TXN8986RYarbanton John Robert · Muskegon, MIN8986VAirline Transport Professionals Corp Of USA · Wilmington, DEN8986WCandler Derrick · Tampa, FLN89877Hillsboro Aero Academy LLC · Hillsboro, ORN89878Corwin Shawn M · Tucson, AZN8987LScholten John E · Marne, MIN8987VPiper Capital Growth Fund LLC · Scottsdale, AZN8987WSonrise Aviation LLC · Lake Havasu City, AZN8987YHanson William D · Soldotna, AKN89881Fulton Gene · Spartanburg, SCN89887Pea-Wayman Flight LLC · Daytona Beach, FLN8988CEastin Toby M · Jefferson City, MON8988JMerkle Hunter T · Mattawa, WAN8988RYoung Andrew J · Eagle River, AKN8988VWahle Daniel C · Missoula, MTN8988WGonzaga Michaelr · Chino Hills, CAN8989JJohnston Family Clinic Inc · Meridian, MSN8989XCascadia Aircraft LLC · Sandpoint, IDN898AMyers D M · Vancouver, WARevoked, canceledN898AMWyatt LLC · Hot Springs, SDN898ATCxk1 LLC · Wilmington, DEN898DANopat LLC · North Charleston, SCN898DKPratt Christopher J · Dallas, TXN898GAtp Aircraft 9 LLC · Wilmington, DEN898JRKokosa Vernon R · Dennis, MAN898JWWeiswasser Jonathan M · Montclair, NJ
Back to AD 81-18-04 R2