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.
N701HDDerendinger Michael L · Holts Summit, MON701HGGeorgia Aviation Authority · Eastman, GAN701KENorthern Jet Sales LLC · Port Saint Lucie, FLN701LYork Nancy Lu Executor · San Angelo, TXN701LULiberty University · Lynchburg, VAN701PCMiramon Peter C · Salem, ORN701PYVallala Dino D · Milton, WAN701RALaith Aviation LLC · Goose Creek, SCN701SDRescue Ministry Corp · Haines City, FLN701SPScandinavian Aviation Academy Inc · El Cajon, CAFirst renewal noticeN701SXEastman Douglas Frank · Thornton, CON701THSmoke Seen LLC · Farmingdale, NYN701WMB&B Aerospace LLC · Rosamond, CAN7020BCutler Frank W · Leona Valley, CAN7020KHeuer Quinn K · Bemidji, MNN7020QAufderheide Flying Service Inc · De Witt, ARN7020RJwe Aviation LLC · Sugar Hill, GAN7020WDavila Antonio · Cudjoe Key, FLN7020YMehrhoff Stanley E · Prairie Home, MON7020ZMeyering Clinton · Southgate, MIN7021BNewby Michael E · Pingree Grove, ILN7021WRichardson Garrett W · Mason, MIN7021YShira William G · Savannah, GAN70220Perun Av LLC · Cliffside Park, NJN70222Aqualion Holdings Inc · Pasadena, MDN70225Southeast Flight Leasing LLC · Cumming, GAN70228Eagle Sky Patrol Inc · Deadwood, SDN7022BSibille Keith C · Griffin, GAN7022QChant Savanah B · Baggs, WYN7022VCjsm LLC · Winter Haven, FLN7022WHall Wesley B · Hot Springs, ARN7022XGuy Jeffrey · Centerburg, OHFirst renewal noticeN7023PHanna Trenton W · Lakeland, FLN7023QHudson Valley Flight LLC · Wappingers Falls, NYN7023RPushpull LLC · Montgomery, TXN7023VJackson William G · Clinton, MDN7023YMaki Stephen B · New Port Richey, FLN7024BNelson Daniel D · Omaha, NEN7024PAnderson Richard · Dickson, TNN7024QWells Nathan S · Scotia, NEN7024TCorrigan Joseph M · San Marcos, CAN7024USpitzer Helicopter LLC · Woodland Hills, CAN7024YAnderson David J · Gardnerville, NVN70256Winn Edwin F · Louisville, KYN7025CDowning Gregg R · Guymon, OKN7025ELyon Emery F · Welsh, LAN7025PA Precious Life Flight LLC · Bend, ORN7025USchultz Walter J · Pine Beach, NJN7025WBerberich Edward C · Gillette, NJN70267Evans Michael J · Rowlett, TX
Back to AD 81-18-04 R2