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.
N687JAYale Companies LLC DBA Hot Wings Aviation LLC · Indianapolis, INN687KBBoekelheide Kim · East Greenwich, RIN687LHChristiansen Aviation LLC · Wilmington, DEN687LPForgotten Heroes Foundation · Chesapeake, VAN687MSScnicto LLC · Lewes, DEN687NDAscent Aviation Inc · Duluth, MNN687RTFvx Research · Greenville, DEN687SPBmg Aviation Inc · Bloomington, INN687SSSciscoe William D · Dish, TXN687VRGriffin Larry W · Wynne, ARN68806G&M Aircraft Inc · Wheat Ridge, CON68808Mrb Aviation Inc · Lexington, SCN6880BAllmaras Donald P · New Rockford, NDN6880NLawrence John J · Cypress, TXN6880PBryant Michael E · West Chester, PAN6880VCraft Steven W · Port Saint Lucie, FLN6880WRegistered aircraftN6880ZMayes Brett R · Williams, CAN68810Air-Planes LLC · Soddy Daisy, TNN68812Avcorp Holdings Inc · Jackson, MIN68813Vogt Jeffrey D · Pleasant Grove, CAN68814Spooner Wade G · Donalsonville, GAN68815Skippy Aviation LLC · Bridgeport, PAN68816Mirkovic Alex · Friendswood, TXN6881KTime 2 Fly LLC · Baldwinsville, NYN6881NMorris Michael R · Columbus, OHN6881UElliott James C · Parker, CON6881VCox Colin T · Harbinger, NCN6881WLewis Mark A · Ozark, ALN6882PKrumel Bradley · Omaha, NEN6882UHoecher Robert T · Anchorage, AKN6883BSlagle Allen E · Newcastle, WYN6883JRobbins John L · Crossville, TNN6883KDrb Helicopters LLC · Klamath Falls, ORN6883NAj Mooney LLC · Port Saint Lucie, FLN6883VHubbell Carl · Crowley, TXN6883ZFoster Gary L · Palmer, AKN6884HWings Over Texas Holdings LLC · Denton, TXN6884JHbk Flyers LLC · Alton, ILN6884KWyatt Mary Ellen Personal Representative · Weirsdale, FLN6884NLutes Kent A · Tazewell, TNN6884USheaffer Bruce R Jr · Lititz, PAN6884VVan Dyck Ryan G · Talent, ORN6885HRasmussen Stewart · Santa Barbara, CAN6885NPoskevich Douglas · Deland, FLN6885UGranier Bernie C Trustee · Bandera, TXN6885WMiller Andy D · Marana, AZN6886BOhmans Inc · Gillette, WYN6886HParr Larry · Clarksville, TNN6886JFlanders David J · Madison, WI
Back to AD 81-18-04 R2