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.
N9416JRich Lucas Aircraft Sales LLC · Lincoln Park, NJN9416LOjeda Kathleen · Pearland, TXN9416SAllen Roger B · Gardnerville, NVN9416VCothren Edward W · Ada, OKN9416WGlaser Michael · American Fls, IDN94179Aerophile LLC · Wilmington, DEN9417KWest Bend Air Inc · West Bend, WIN9417LJalomc LLC · Glassport, PAN9417NPrescott Milton B Jr · Glendive, MTN9417VFraembs David G · Canyon Lake, TXN9417ZAmerican Aviation Inc · Brooksville, FLN9418JKleinschmidt David P · Saint Charles, MON9418VSmith James · Lawrenceburg, TNN94194Power Flow Systems Inc · Daytona Beach, FLN9419DKintz Dale K · Astoria, ORN9419JCarr Robert H II · Valentine, NEN9419LDorman Zachery Ray · Mountain City, TNN9419WSumner Scott B · Catoosa, OKN941BJValiair Limited Co Trustee · Casper, WYN941BMGk Transportation LLC · Clarksville, TNN941CPCivil Air Patrol · Maxwell Afb, ALN941DSmith Kevin · Sherman, TXN941DPOzer Cenk · Sequim, WAN941DRCrandall Randy M · Elbert, CON941DSMirror Invincible LLC · Rotonda, FLN941EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN941GArcher Flight LLC · Wilmington, DEN941JWMoses Aviation Services LLC · Uvalde, TXN941KBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN941LFMott Christopher · Punta Gorda, FLN941MPHill John D · Reno, NVN941RBTexas Flight Training Aircraft 8 LLC · Wilmington, DEN941RPHarvey Howard R · Castle Rock, CON941RVDji LLC · Cairo, GAN941SBSarasota Seabreeze Flyers Inc · Venice, FLN941TADo Fly Aviation LLC · Silverdale, WAN941TH941th LLC · Bethany, OKN941TWHodge Flight Services LLC · Pittsburg, CAN941WRRepucci William B · Easley, SCN9420EAero Quest LLC · Costa Mesa, CAN9420LEddleman Russell K · Phoenix, AZN9420NSpace Cadets Inc · El Cajon, CAN9420VAerologic LLC · Yorktown, VAN9421DJeff Air Pilot Services LLC · Shelbyville, INN9421EStroemsvik Kristian · Strasburg, VAN9421JSmith Robert Martin Jr · Port Saint Lucie, FLN9421NMitzoom Montana LLC · Lakeside, MTN9421VKohler Robert · Gilroy, CAN9422LGryske Kenneth R · Pinehurst, NCN9422WEagle Wings Aviation Inc · Cornell, IL
Back to AD 81-18-04 R2