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.
N54EMAvirone Ltd · Monsey, NYN54FDDefibaugh Fred M · Chino Valley, AZN54GACrosswind Leasing LLC · Prescott, AZN54GDCulpepper Mark D · Chapmansboro, TNN54GMCiommo William J · Spring Hill, FLN54HMSky West Aviation Inc Trustee · Albuquerque, NMN54HRAshcraft Matthew Q · Abbott, TXN54HSHenderson State University · Arkadelphia, ARN54HYEngler Eric M DBA · Cass City, MIN54JASan Carlos Flight Center Inc · San Carlos, CAN54JMAviation Institute Of Maintenance · Virginia Beach, VAN54JTEhlers Louis H · Sedgwick, KSN54KAPoint To Point Air LLC · Arlington, WAN54KF5193 Flight LLC · Missoula, MTFirst renewal noticeN54KHHertenstein Kevin Wayne · Lutz, FLN54KKTemple Donald G · Amarillo, TXN54KPScheuers Alan · Murfreesboro, TNN54LHolzsweig Leon Gerald · Dallas, TXN54LFTopliff John · Goodland, KSN54LHThrew Timothy G · Yates City, ILN54LJPoulton Douglas E · Castro Valley, CAN54LPPerry Jeffrey Kevin · Cumming, GAN54LULetourneau University · Longview, TXN54MDDe Marino Michael E · Marietta, GAN54MFFaulkner Max R · Bourbon, INN54MGCarley Kristopher · Sacramento, CAFirst renewal noticeN54MJNychka Robert James Paul · Wills Point, TXN54MKKuhn Morris L · Dallas, TXN54MTMay Rose Ellen · Hampshire, ILN54PPHancock Andrew M · Kettle Falls, WAN54PRReimer Lynn C · Sioux Falls, SDN54RAAshlock Mark L · Loomis, CAN54RLTrimble Steven L · Tallahassee, FLN54RRValentin Jose E · Murrieta, CAN54RSIreland Brian T · Springville, UTN54RVEbrahimi Mazda · Gerradstown, WVN54SGBiondo Nicholas P · Norfolk, VAN54TDG-Loc Fighters LLC · Wilmington, DEN54TLArmstron Kevin L · Corvallis, ORN54TXBail Air LLC · Port Saint Lucie, FLN54VBas Part Sales LLC · Greeley, CON54VAFisheer Eric E · Memphis, TNN54VCStrahler Mark D · Peachtree City, GAN54VVVoutour Ryan R · Tehachapi, CAN54WDHat Creek Aviation LLC · Hamilton, MTN54WEWilson Douglas E · Emporia, KSN54WYBernegger Mark S · West Point, MSN54YEBrown Lonnie S · Lone Jack, MON54ZRPoehlmann Ralph T · Brenham, TXN54ZZNeuman Michael · Vashon, WA
Back to AD 81-18-04 R2