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.
N573MBWigley Barry L · Langston, ALN573MWWhelan Company LLC · Hoover, ALN573NDAir Shares LLC · Casper, WYN573PUTrustees Of Purdue University · West Lafayette, INN573SMason Scott C · Lebanon, ORN573TLAsson David A · Sisters, ORN573TMFarley Douglas C · Edmond, OKN57401Adams Kenneth · Marana, AZN57404Cp Aviation Inc · Santa Paula, CAN57405Shoaf Douglas G · Lake Oswego, ORN57407Britt Elaine L · Locust Grove, GAN57408Phillips Thomas G · Fairbanks, AKN5740HPritchett Michael L · Benton, ARN5740QOasis Aero Inc · Willmar, MNN5740UBraden Daniel · Port Charlotte, FLN5740WAdams Clay · Anacortes, WAN5740ZLashley Chad P · Wentzville, MON57410Eddy William Crawford III · Sugar Hill, GAN57411Gregory Larry C Trustee · Farmington, MON57412North County Flight Training Inc · Carlsbad, CAN57413Miller Sybille A · Ashburn, VAN5741DJ&H Sewing & Vacuum Inc · Soldotna, AKN5741FBrower Alan L · Califon, NJN5741LWienclaw David E · Boise, IDN5741WGonzalez Jose M · Arlington, TXN57420Florida Man Aviation LLC · Saint Petersburg, FLN57421Snider Roger A · Harlem, MTN57422Heefner Frederick C · Greencastle, PAN57423Pardue Roy S · Clifton, VAN57424Wood Flying Inc · Panhandle, TXN57428Zygomalas Stefanos · San Francisco, CAN5742DHemminger Blair · Gwinner, NDN5742LGjorvad Steven A · Punta Gorda, FLN5742UAdams Sara · Leavenworth, KSN5742WJohnson Ronald H · Goodlettsville, TNN5742ZBootz Terry A · Canyon Lake, TXN57430Swanson Michael D · Council Bluffs, IAN57433Propwash LLC · Princeville, ILN57435Morkassel Gerald N · Waverly, OHN5743LHead William J · Verona, KYN5744Keller Kevin M · Sylvania, OHN57440Frankel Daniel A · Madison, OHN57442Whiting Lawrence M · Silverton, ORN57446Williams Martin · Wasilla, AKN57447Hicks Richard Ted · Statesville, NCN5744DDempsey Timothy P · Pacific, MON5744ULance Sylvia · Acushnet, MAN5744WGarrett Jackson Trustee · Pleasant Garden, NCN57454Ck Leasing Services LLC · Wilmington, DEN57456Marshall James I · Roosevelt, UT
Back to AD 81-18-04 R2