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.
N97PBlack River Construction Services LLC · Black River Falls, WIN97PFSoaring Eagles Flying Svc Ltd · Edwards, ILN97PLLarson Preston A · Webster, MNN97PRBiggers Jarett J · Alexandria, VAN97PZStoraasli Paul · Torrance, CAN97RADavis James K · Vero Beach, FLN97RKKeenan Michael P · Ankeny, IAN97RPCombs Jonathan R · Girdwood, AKN97RTDoran John F · Charlestown, RIN97RVLindberg Stephen J · Tumwater, WAN97RWWiplinger Robert D · Inver Grove Hts, MNN97SARegistration Pending · Peosta, IARegistration pendingN97TKDekalb Aviation LLC · Williston, NDN97UAManufacturing Services And Solutions LLC · Lake Villa, ILN97UPMf Helicopters LLC · East Troy, WIN97VACamps Bay Aviation LLC · Waukegan, ILN97VPAtkins Louis Clifford Jr · Birmingham, ALN97WButler William E · Idaho Falls, IDN97WHCox Thomas R · Kirkland, WAN97WKPantas James S · Mount Pleasant, NCN97WYCentral Copters Inc · Bozeman, MTN97XCN97xc LLC · Milpitas, CAN97XTRobertson Paul L · Knoxville, TNN97XZAllen Nathanael W · Bemidji, MNN97YMueller Dan W Jr · Maryland Heights, MON97ZZMx7 LLC · Hudson, OHN98001Goltsos William · Barrington, RIN98009Lebron Renard Luke Jr · Gulfport, MSN9800PGrisham Steve DBA · Belzoni, MSN9800UHarvey Mallory · Baxley, GAN9800WMrd Aero LLC · Manheim, PAN98012Registration Pending · West Sacramento, CARegistration pendingN98014Bas Part Sales LLC · Greeley, CON98015Rd Aire LLC · Opelika, ALN98017Blakeslee Vernon A Jr · Torrington, CTN9801WNorth Little Rock Air Inc · North Little Rock, ARN98021Wright Joseph R · Perry, GAN9802AAtp Aircraft 7 LLC · Wilmington, DEN9802UStoll John E · Summerville, SCN98037Hammer Joseph K · Dike, TXN9803CWhite Traci M · Manasquan, NJN9803DAttitude Aerobatics LLC · Wilmington, DEN9803PLosse Randall J · Wasola, MON9803YHubbard Nathan · Butte, MTN98041Rosman Patrick R · Creston, WAN98043Paul Lester E Jr · Okoboji, IAN9804DEngbring Tim · Valmeyer, ILN9804WHoyos Luis · Fort Pierce, FLN98055Shkvarok Roman · Staten Island, NYN98059Airplane LLC · Fort Collins, CO
Back to AD 81-18-04 R2