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.
N8086GMason Aviation Club LLC · Mason, MIN8086HCloud Catcher Aviation LLC · Great Falls, MTN8086KClubs 2 LLC · Calabasas, CAN8086NDakota Group Inc · Rockaway, NJN80870Robben William J · Pampa, TXN80871Monnin Aviation LLC · Amherst, NYN80872Yakima 872 Flying Club · Yakima, WAN80874Jls Aviation LLC · Fredericksburg, VAN8087BMach Point One LLC · Nashville, TNN8087CHartzell Propeller Employees Flying Club · Piqua, OHN8087DRa Aviation Services LLC · Sorrento, FLN8087PWildman Kevin · Brentwood, CAN8087YGlen John L · Warrenton, ORN80881Bizzjet Inc · Kalispell, MTN80884Rein W Clark · Ottawa, KSN8088BRegistered aircraftN8088CVouk Frank E · Firth, IDN8088YBarazani Jacob J · Chanute, KSN80896Dsr-Cherokee 180 LLC · Dallas, TXN8089CNelco Farms Inc · Fairfield, IAN8089ESkywarrior Flight Training Inc · Pensacola, FLN8089GWellman Steven R Trustee · Englewood, FLN8089PBerryhill Daniel R · Darwin, MNN8089WBrind F Alan · Ionia, NYFirst renewal noticeN808BBPlane Fun Aviation LLC · Wilmington, DEN808BFCarter Ephraim A · Stanwood, WAN808BPChemtech-Engineering Inc · Racine, WIN808BWWeber William A · Brodhead, WIN808DCWaters John Klas · San Marcos, CAN808DDBoucher Bobbi · Fredericksburg, VAN808DJAeroquest LLC DBA · Olive Branch, MSN808DMRhoads Timothy C · Logan, NMN808EHChristiansen Aviation LLC · Wilmington, DEN808ERDurcan David · Kingston, NYN808FLBrand Richard Jr · Alta Loma, CAN808GJWait Kyle L · Palmer, AKN808JAGrubb John P · Booneville, ARN808JRTexas Air Museum Inc · San Antonio, TXN808JTVu Ai T · Aiea, HIN808KThompson Dale C · Huntsville, OHN808KASchlomer Lyle M · Osseo, WIN808LLApex Helicopters LLC · Pearland, TXN808MWMy Wings LLC · Senoia, GAN808NRegistration Pending · Sarasota, FLRegistration pendingN808PWederski Lonnie E · Yarnell, AZN808PBDaniel Jeffrey Austin · Southampton, NJN808PEBarbers Point Flight School LLC · Kapolei, HIN808PKGottmann Matthias L · San Jose, CAN808PTDancing Bear Alaska LLC · Talkeetna, AKN808PYCollins Robert A · Modesto, CA
Back to AD 81-18-04 R2