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.
N55308Charger 308 LLC · Hollis, OKN5530JSellers Justin Kennedy · North Augusta, SCN5530WHobgood Sidney · Klamath Falls, ORN5530ZReeves Todd J · Mosier, ORN55310Monarch M Miller · Cloverport, KYN55311Aeras Transport LLC · Lewes, DEN55313Dunning Mark · Chino Hills, CAN55315Norman Eric Lee · Hilton Head Island, SCN55317Schwader Aviation LLC · Saint Joseph, MON55319Guckin Michael E · The Villages, FLN5531FSchmidt David D · Atlantic Mine, MIN5531HXin Han Aviation LLC · Atwater, CAN5531MPeterson Jay O · Las Vegas, NVN5531ZDarr Henry S · Drummond, MTN55320Dragon Flight Training Academy LLC · Pembroke Pines, FLN55325Hater Michael A · Cincinnati, OHN55327Grise Paul R · Hopkinsville, KYN5532JRegistration Pending · Trinity, FLRegistration pendingN5532PHoudek Todd L · Roseburg, ORN5532SAks Aviation LLC · Arroyo Grande, CAN5532UGorman Jeremy J · Chapman, KSN55330Eaw Aviation LLC · Middletown, MDN55331Scholl Oil & Transportation Company · Holyoke, CON55338Pt Arts LLC · Grand Rapids, MIN5533BKnudson Eddie T · Arvada, WYN5533FCopenhaver Ralph L · Brady, TXN5533PRado Richard L · Fortville, INN5533QBoldt Matthew Frederick · Santa Fe, NMN5533RThompson Aaron R · Louisville, KYN5533SNgb Construction Inc · Ceres, CAN55340Air55 LLC · Charleston, WVN55342Dienwiebel Thomas · Santa Cruz, CAN55345Arrow Flite LLC · Chino Hills, CAN55347Roze Scott L · Port Orange, FLN55349Mob Aviation LLC · Auburndale, FLN5534ELindsey Kelly M · Throckmorton, TXN5534KAerolife Aviation LLC · Knox, INN5534QPaul Richard W · San Jose, CAN55350Haps Air Inc · Ames, IAN55359Uribe Roberto · Houston, TXN5535FTrent Donald R · Rustburg, VAN5535JBreadner Robert A · OntarioNon-citizen corporation, flight hours not reportedN5535KHays Cory · Beaumont, TXN5535MButz Jonathan O · Mansfield, OHN5535QJohnson Bar Inc · Pensacola, FLN5535ZPayne Dustin J · Weirsdale, FLN55363Hardin John M · Terrell, TXN55364Cremel Roberto J · Trumbull, CTN5536EJeffries And Hendley LLC · Greenwood, INN5536FArnt James R Jr · Worthington, MN
Back to AD 81-18-04 R2