AD 2004-19-01
Registered aircraft · 30,427
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:2004-19-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-19-01')
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:2004-19-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-19-01') 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.
N103DLDunwoody Duane E D · Savage, MNN103PBBentley Jeffrey W · Kenmore, WAN103SGJared William C · Valparaiso, INN10410Clark George A · Worcester, MAN10420Kinney Powell Mcvay · Coppell, TXN1042GPorter David G · Stuart, FLN10433Sodak Angus Inc · Reva, SDN1044DMcadam Charles T · Wichita, KSN1044GVoelkerding William Michael · Fairbanks, AKN1044SHubbell Wallis E · Tucson, AZN104AFNance David B · Quinton, VAN104BU1984k LLC · Gypsum, CON104FDDippolito Michael M · Norristown, PAN104JVPryor Michael C · Riverview, FLN104KJb Aircraft LLC · Anchorage, AKN104NRMiller Dale D · Eagle River, AKN104PMPats Offroad Inc · Mitchell, SDN104RCChan Ronald G · Anchorage, AKN104SKAerospace Trust Management LLC Trustee · Wilmington, DEN1050VState Of Wisconsin · Madison, WIN10534Shergi Nikolai W · Franklin, INN1058DMorley Philip · Manhattan Beach, CAN1058MAir Combat Museum · Springfield, ILN1059RDoyle Brian G · Windsor, MAN105DPPulscher Brian J · Sand Springs, OKN105RDSunny Slope Aviation LLC · Adams, TNN1067MShore Enterprises Of Gainesville LLC · Gainesville, FLN1069LWilson Michael A · Everett, WAN106RGCadena Edward R Jr · Houston, TXN106UMiha LLC · Dover, DEN1071MJesperson Kenneth R · Ekalaka, MTN1073YGoedicke Walter H Jr · Bay Head, NJN1074DBarron Aviation LLC · Perry, MON10769Waddingham William B · Rancho Cucamonga, CAN1077DBarron Aviation LLC · Perry, MON107PSLadies In Aviation LLC · Mocksville, NCN107SKFitzpatrick William M · Cleveland, GAN107WFWilcox Farms Inc · Roy, WAN1080DLindsey Paul Robert · Quinlan, TXN1081DMilton William H · Amsterdam, NYN1081WPeck Alan W · Chattanooga, TNN1082PGarrett James D Jr Trustee · Coolidge, AZN1086LLade Burton G · Bemidji, MNN108CCFlaugher Jonathan S · Poquoson, VAN108EENorthwood Services Inc · Skwentna, AKN108GWPope James D · Clarkston, WAN108SPDale County Sheriffs Office · Ozark, ALN108TSHesser Dale W · Cardington, OHN1096DDaugherty Lowell E · Adelanto, CAN1098DDoyle Terry · Grapevine, TX
Back to AD 2004-19-01