AD 71-13-01 R1
Registered aircraft · 6,916
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.
N501GWSouthwest Aviation Enterprises · Haslet, TXN501PB34 North Holdings LLC · Ventura, CAN501TMagic Carpet LLC · Hampton, NHN5020ABrown Jonathan Corey · Sherman Oaks, CAN502EUMirage N502eu LLC · Benton Harbor, MIN5033TJulol Investments LLC · Miami, FLN503JALiem David H · Brea, CAN503VFC&H Aviation LLC · Greenwood Village, CON504HLYellow Peril Aero LLC · Richmond, TXN5054TWebb Larry R · Lima, OHN50588Registered aircraftN505HVHelivision LLC · Concord, NCN505JWCampbell Matthew P · Visalia, CAN505RAFlying J Holdings LLC · Austin, TXN5061CMatheny Robert Gregg · Kingman, AZN5066HDohr William F · Williamsburg, VAN506CVail Jeffrey · Kennett Square, PAN506PAState Of Connecticut · Hartford, CTN506TMTall Timber Flying Service LLC · Kalispell, MTN507JBDi Marco Michael G · Orlando, FLN507MAAviation Consultants US Inc · Beaver Falls, PAN50848Carroll Jacob · Oklahoma City, OKN508ACKtaz Air LLC · Niceville, FLN508YLally Michael M · Miami, FLN50BFStephenson Keith · Studio City, CAN50CCScott Macdonald Aircraft Sales Inc · Stuart, FLN50DJWest Chester Air LLC · West Chester, PAN50PSExecutive Airshares LLC · St Thomas, VIN50RNOn Three Angels Wings LLC · Melbourne, FLN50TGTgi On-Top LLC · Woodland, CAN50VVVictor Victor Leasing LLC · Pompton Plains, NJN5107YBrown Peter B · Salem, VAN510ADDj Aztec LLC · Springfield, OHN510CCAwmr LLC · Conroe, TXN510KCProcoff LLC · Shreveport, LAN5114JGates Joanne L Trustee · Pittsburg, TXN511CABas Part Sales LLC · Greeley, CON511HGCastor David · Palm Coast, FLN511HPPattison Aero Inc · Henderson, NVN5127WRegistration Pending · Kalispell, MTRegistration pendingN512CSky West Aviation Inc Trustee · Albuquerque, NMN512DPCanal Aviation LLC · Dover, DEN512EZCmtg Real Estate Enterprises Inc · Lakeland, FLN512FGLcb Leasing · Bristow, VAN512TNexus Air LLC · Williston, NDN5134BSalinas Four LLC · Salinas, CAN5139WConnelly James · Spearman, TXN513FMenzia Brian Edward · La Valle, WIN513HPVeracity Aviation LLC · Seguin, TXN513KMFreedom N513km LLC · Pacific City, OR
Back to AD 71-13-01 R1