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.
N6294TGreater Flint Pilots Association · Flushing, MIN6294ULamontagne Brian D · Wyandotte, MIN6294VColomello Charles P · Tillson, NYN62953Dodge Inc · Wilmington, DEN62954Big Bend Community College · Moses Lake, WAN6295DCandace A Larned Enterprises Inc · Long Beach, CAN6295LGordon Fredrick · Brooksville, MSN6295URawareo LLC · Warsaw, MON6295WJ Delgado Aviation LLC · Tulsa, OKN62960Fossen Kenneth J · Omaha, NEN62968Stanley Farms · Grygla, MNN62969Ls Aviation LLC · Searcy, ARN6296FCivil Air Patrol Inc · Maxwell Afb, ALN6296LHansen Roy J · Pacific City, ORN6296NBurg Clinton A · Creswell, ORN6296WBarthell Frederick · Sun City West, AZN62975Quintessence World LLC · League City, TXN62977Borgerding Richard · Piqua, OHN62979Cummings Roy E · Fort Scott, KSN6297JYale Aviation Inc · New Haven, CTN6297UBeasley Curtis L · Kennewick, WAN6297WDevils Lake Aero Repair Inc · Devils Lake, NDN62982Peterson Derek R · Kenmare, NDN62984Hopkins George · Chippewa Falls, WIN6298JPlane Fun Inc Tr Trustee · Snellville, GAN6298MLapham John R · Palm Beach Gardens, FLN6298PN6298p Inc · Okeechobee, FLN6299DJav Air Services LLC · Anchorage, AKN6299UKeelin Freddie B · Sagle, IDN629AHSuburban Air Corp · Castro Valley, CAN629AKCloward Marc D · Cordova, AKN629APThomas Lucas G · Beebe, ARN629BWagner Nathan D · Dane, WIN629BCVolar V LLC · Edmond, OKN629CGC-4 Aviation LLC · Fruitland Park, FLFirst renewal noticeN629CPCivil Air Patrol · Maxwell Afb, ALN629EMMelendez Carlos M · Saint Petersburg, FLN629EREmbry-Riddle Aeronautical University · Prescott, AZN629ESKorenek Michael A · Houston, TXN629FCDoherty Paul A · Van Buren, ARN629FTFlorida Institute Of Technology · Melbourne, FLN629GKTumenas Daniel E · Girdwood, AKN629GWPage Cathleen A · Tucson, AZN629HBBattle Creek Powersports LLC · Jasper, TNN629JCCzachorowski Joseph · Wilmington, DEN629JMWebster Bart H · Queen Creek, AZFirst renewal noticeN629KHarrill Roy K · Columbia, SCN629LMackay Restaurant Management Group Inc · Seattle, WAN629LECloward Max S · Draper, UTN629MBBelleau Clifford D · Anchorage, AK
Back to AD 81-18-04 R2