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.
N73502Greenbrier Valley Flyers Inc · Wht Sphr Spgs, WVN73504Abriam Darryl · Jacksonville, FLN73505Tex Air LLC · Springfield, MON73508Hoyt Max A · El Dorado, KSN7350GFox Victor Aviation LLC · Newnan, GAN7350HBazarnic Richard P · Tempe, AZN7350JVero Technical Support Inc · Pensacola, FLN7350KSmith Randy Kayle · Vancouver, WAN7350RScenic Concepts LLC · La Crosse, WIN7350WLisa Mark P · Paso Robles, CAN7350ZScott Ts Ag Flyin Inc · Colquitt, GAN73510Adams Rodney G · Topinabee, MIN73516Aviation Captial Management LLC · San Jose, CAN73519Usaeroflight LLC · Greenville, SCN7351GMiddlebury Flying Club Inc · Middlebury, VTN7351JRudolph Robert E · Martinez, CAN7351KFordham Gary B · Goldsboro, NCN7351LTaigen Robert L Jr · Queen Creek, AZN7351PSutliff Larrie G · Briarcliff Manor, NYN7351WMoser Jeffrey E · Creighton, NEN7351YDunne Brian T · Wichita, KSN73524Dramstad Flying Service LLC · Helena, MTN73525Magras Michael G Trustee · Sahuarita, AZN7352DStrickland James M Jr · Whiteville, NCN73530Saffron Aviation LLC · Cookeville, TNN73535Magnusson Michael J · Munnsville, NYN7353GWoodliff Alexander Harrison · Truesdale, MON7353KIvey Thomas S · Gladewater, TXN7353WSales Michael · Delphi, INN7354DKerven Enterprizes Inc · Butler, PAN7354GRight Rudder LLC · Rexburg, IDFirst renewal noticeN7354J7354j LLC · Colorado Springs, CON7354WAmico David A · Newburyport, MAN7354YBreum Todd R · Billings, MTN7355DSlavens Trent S · Whitehall, MIN7355GAerolanding LLC · Enterprise, ALN7355JCzyszczon Aviation LLC · St Pete Beach, FLN7355PGo Fly Az LLC · Gilbert, AZN73560Gospel Ministries International Inc · Collegedale, TNN73562Steiger Michael P · Cypress, TXN73563Hamms Lake Development Inc · Crown Point, INN7356GHolcomb John R · Siloam Springs, ARN7356JHyatt Philip D · Gadsden, ALN7356LCrosetto Pierre F · Downey, CAN73573Sullins Tyler L · Boerne, TXN73574Wingsleasing LLC · Wichita, KSN73577Benton Frederick N · Weed, CAFirst renewal noticeN73579Officer Properties LLC · Broken Arrow, OKN7357DColton F D · Canby, ORN7357JCswnz Inc · Wilmington, DE
Back to AD 81-18-04 R2