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.
N2316XJnj Aviation Inc · Wilmington, DEN2318LButerbaugh Richard A · Summerville, SCN23207Ttp Aviation LLC · Concord, NCN23215Bill Webb Construction Inc · Chico, CAN2325JLesterville Land Holdings LLC · Ellington, MON232CASawdust Aviation Inc · Bellefonte, PAN232JMWillfish LLC · Mentor, OHN232MJNby Productions · Bristow, VAN232TJCsc Delaware Trust Co Trustee · Wilmington, DEN232TSTwo Tango Sierra LLC · Edmond, OKN232YPGill Joshua Daniel · Tucson, AZN233TSLittle Sunflower LLC · Bridgewater, CTN234AGLop LLC · Orangeburg, SCN234BLSullivan Leo W · O Fallon, ILN234CEAir Arctic Inc · Fairbanks, AKN234DLAngel Wings LLC · Waxhaw, NCFirst renewal noticeN234HESchniederjan William Jason · Dalhart, TXN234JFInternational Air Services Inc Trustee · Carson City, NVN234MFGone Flying LLC · Salt Lake City, UTN23530Registration Pending · Grapevine, TXRegistration pendingN2353HBlackbird Enterprises LLC · Las Vegas, NVN2355PDice Jeremy L · Redmond, ORN23563Aircraft Leasing And Sales LLC · Riviera Beach, FLN2359GAllison Farms Inc · Wray, CON2365FBottorff Jon C · Fishers, INN2365JBrosius Michael W · North Platte, NEN2365SIe3 Enterprise LLC · Elk Grove, CAN2369AValiair Lc Trustee · Casper, WYN2369WRoyal Kenneth L · Savannah, GAN236CMWright Kim B · Anchorage, AKN2370XSouthwest Aircraft Enterprises · Haslet, TXN2371HSan Jose Aviation LLC · Mission, TXN23781Paragon Air Group · Fort Worth, TXN2378XState Of Utah · Salt Lake City, UTN2378YLindsey Aviation Services · Haslet, TXN2379FWebster Douglas Clark · Las Vegas, NVN237CLnh Holdings LLC · Richardson, TXN237MAR E Dimond And Associates Inc · Indianapolis, INN237REDobbert Thomas · Reno, NVN2381YInvictus Investments LLC · Urbandale, IAN2383LNebraska State Patrol · Lincoln, NEN2389GMacon Septic Systems Co Inc · Macon, MSN2389LCjw Holdings LLC · Stamping Ground, KYN238CSD H Hutson Enterprises Inc · Waxhaw, NCN238MChe Brothers LLC · Winters, CAN238TLLow Sean · Midland, TXN2391EInnova Energy LLC · Wilmington, DEN23BQCentral Airlines Inc · Overland Park, KSN23DKStockwell Aviation LLC · Clarence Center, NYN23LLAjca Farms LLC · Kalispell, MT
Back to AD 71-13-01 R1