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.
N9423BDrean Alelandre C · Ajo, AZN9423FAvex Holdings Heli Inc · Lewes, DEN9423JDt Pralle Enterprise Inc · Hampton, IAN9423KThompson Shane E · Warroad, MNN9423NCox Ricky L · Bell Buckle, TNN9423VLevin Robert G · Roseburg, ORN94247Solberg Aviation Co Inc · Whitehouse Station, NJN9424DBranch Clayton L · Winfield, KSN9424EAero Equities LLC · Ventura, CAN9424FOwens Mark T · Zionsville, INN9424WWilliams Ronald W · Prescott, AZN9425HWingsleasing LLC · Wichita, KSN9425JWachusett Flying Club Inc · Princeton, MAN9425LSiegel R J · Bayside, WIN9425NSpaniol Mark · Lula, GAN9425VEcaviators LLC · Wilmington, DEN9425WPopejoy Arthur T · Hanford, CAN9426EDarcy Aviation LLC · Danbury, CTN9426J4hx LLC · Dallas, TXN9426LKohout John S · Terrell, TXN9426NClodfelter Chet · Roachdale, INN9426VTwo Guys One Plan LLC · Clermont, FLN9426WTitan Aero LLC · Little Rock, ARN94270N94270 LLC · Chesterfield, NJN9427LGaiss Randolph M · Lake City, FLN9427NSchool Board Of Bay County Fl · Panama City, FLN9427VBrack Enterprises LLC · Indianapolis, INN94286Purdue Aviation LLC · West Lafayette, INN9428FBargo Aviation Services LLC · Crittenden, KYN9428LBarrett Lewis E II · Woodstock, GAN9428NYatteau Michael G · Woodbridge, CAN9428VMcconnaughhay Ken · Searcy, ARN9428WHodge Steve · Denison, TXN94292My Way Aviation LLC · Weston, FLN9429VFrankel Daniel A · Madison, OHN942BBSeibert Joseph John · Cincinnati, OHN942CMalavolti Ethan J · Terre Haute, INN942CABaca Flavio Tomas · Vail, AZN942FAPropability One LLC · Daytona Beach, FLN942FLJochnma Steven J · Aumsville, ORN942JFLuke James Michael · Austin, TXN942LBWade Ronald · Lake Stevens, WAN942LCRegistered aircraftN942MACorderman Michael · Armstrong, IAN942PTGarboden Patrick N · Katy, TXN942RRegistration Pending · Glenmoore, PARegistration pendingN942SBGarvey John D · Timbercreek, TXN942TBillen Jarod H · Lakeland, TNN942TALost Squadron Inc · Wilmington, DEN942TBBailey Thomas R · Benton, KY
Back to AD 81-18-04 R2