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.
N6636LAoa Kissimmee Inc · Kissimmee, FLN6636TVincent Air LLC · Carroll, IAN6636UBurcham Jaime S · Advance, NCN6637JCaison Rodney D · Carrollton, VAN6637PEbner Rudy · Orange, TXN6637RSchawang Darrin E · Falls City, NEN6638BAhmed Gedi A · Saint Paul, MNN6638HWright Aero Inc · Saint Cloud, MNN6638LNewby Danny A · Mc Leansville, NCN6638WTugmon Danny · Locust Grove, OKN66399Acord Aviation Co L L C · Chandler, OKN6639DBig Bend Community College · Moses Lake, WAN6639JColoski Dennis J · Marlton, NJN6639PMustain Michael J · Monticello, GAN663ABBald Allan D · Alton, NHN663AFSnelling Peter G · Thornton, PAN663BFFoster Robert B · Erie, PAN663CPCivil Air Patrol · Maxwell Afb, ALN663DHEmig Terry · Casa Grande, AZN663DSButler Raymond · Port Lavaca, TXN663DXSouthtec Inc · Wilmington, DEN663GMMitchell David · Carrollton, GAN663NDUnd Aerospace Foundation · Grand Forks, NDN663RTRaiders Tigers Flying Club Inc DBA · Houston, TXN663RVPlaxco Mitchell O · Huntsville, ALN663SMMacmoyle Scott · Blairstown, NJN663WTSkywest Leasing Inc · St George, UTN66405Mh Aviation LLC · Foster City, CAN6640HSolis Aviation LLC · Carroll, OHN6640JHeesch Donald · Nunn, CON6640PAlexander Paul S · Selma, ALN6640VCarlsbad Raceway Corp · Hemet, CAN6640WAldrich David G · Naples, FLN6641JStratus Business Development LLC · Nashua, NHN6641PMartinous Shawn A · Providence, RIN6642JFive By Ten LLC · Loveland, CON6642UCrawford Daniel G Trustee · Dryden, MIN6642WBrown Kevin D · Saint Louis, MON6643JJohnson Steve · Attleboro, MAN6643WWeiss Stephan T · San Jose, CAN6644MSierra Lima Aviation LLC · Riverton, UTN6644ZKing Jonathan R · Palmer, AKN6645AAlmost There Air LLC · Daytona Beach, FLN6645JMcdonald Neill F Jr · Fairfax, VAN6645UFreemont Investors Inc · Bainbridge Island, WAN6645WHolman Robert S · Delta, UTN6646HIowa Great Lakes Flyers Inc · Cheyenne, WYN6646JNoize Farm Inc · Cheyenne, WYN6646WCordova Jesse · Raymore, MON6647UMouton Charles J Jr · Gladewater, TX
Back to AD 81-18-04 R2