AD 71-13-01 R1
Registered aircraft · 6,915
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:71-13-01-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:71-13-01-R1')
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:71-13-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:71-13-01-R1') 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.
N222SNNorris Jason M · Smyrna, TNN222WBPower Robert R · Brenham, TXN222WPFord Scott S · Punta Gorda, FLN222ZMPresentation Impact LLC · Sandia Park, NMN22316Mcleland David L · Sellersburg, INN2231XCaselato Andre Luiz Puls · Kissimmee, FLN22320B Lillico Petroleum Consultants Ltd · Eastport, IDN2232ZAlaverdi Omeed · California, MDN2234UMountain States Casing Co LLC · Timnath, CON22363Barnes Welding Inc · Waterville, WAN22370Top Flight Sales Inc · Wilmington, DEN2237AKimber 123 Holdings LLC · Morgantown, WVN2237SOregon State Police · Salem, ORN223DAAerodrome LLC · Louisville, KYN223JMEid Bradley · Greenwood, INN223MDPremier Engineering Inc · San Antonio, FLN223MSNy Dc LLC · Washington, DCN223TB416b Heritage Hills Dr LLC · Palm Harbor, FLN22412Time Flies LLC · Oak Brook, ILN2241BHanneman Michael W · Abilene, TXN2243FDavenport Mark B · Placentia, CAN22446Ag Care Inc · Apopka, FLN2244QField George Jr · Overton, NVN22450Red Mountain Express Care LLC · Queen Creek, AZN2245ANo Limits Aviation Group LLC · Louisville, KYN2247ABcs Aviation LLC · Colquitt, GAN224CSAtb Special Purpose LLC · Laredo, TXN224JJCox Gerald Lee · Shepherdsville, KYN224TFCdtskyview LLC · Medford, ORN2252ZBerman Rayanne S · Hatfield, PAN2255HWinged Vision Inc · Gaithersburg, MDN2255MCooper Gary D · Fayetteville, ARN225AVY-O Cattle Co LLC · Laredo, TXN225EBEbac LLC · Wichita, KSN225HMSmithart Eric W · San Juan, PRN225KTAnselmetti Federico · Miami, FLFirst renewal noticeN225MCP46 Tango LLC · Friday Harbor, WAN225METvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN225VPAerotrust Services Corp Trustee · Wilmington, DEN225ZMoe Kevin · West Chester, OHN2265QMyl High Flying Club LLC · Mccall, IDN2265WStratus Aviation LLC · Fergus Falls, MNN2266KFelix Ken Allen · Rye, CON2268BNitro Aviation LLC · Englewood, CON2269BAh1f Associates LLC · Clifton Park, NYN2269MSpencer Donald I Jr · Knoxville, TNN226BVKimberlin G Tyler · Fairbury, NEN226JWThompson Edward Allen · Sunset Beach, NCN226MELawson Tim · San Clemente, CAN226TMWadeberg LLC · San Francisco, CA
Back to AD 71-13-01 R1