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.
N888WPVantage Point Aviation LLC · Ormond Beach, FLN888YAAds-B Technologies LLC · Anchorage, AKN8890PElliott Charles · New Smyrna Beach, FLN8891PTobias Ethan · West Haven, UTN8892PN8892p LLC · Glendale, AZN8893ERegistration Pending · Pompano Beach, FLRegistration pendingN8894PGarms Walter I III Trustee · Berkeley, CAN8897PFey Ray D · Middleton, WIN8899PLavoie Paul · Macon, GAN889ACKdx Air Ventures LLC · Naples, FLN889DRNiner Delta Romeo LLC · Sheridan, WYN889MWI S O Art Ltd · Hamilton, MTN88CMTurner Ronald A · Tulsa, OKN88CXChamplin Aviation LLC · Kerens, TXN88EBRegistered aircraftN88HLLiberty Aero LLC · Carlsbad, NMN88NPRegistration Pending · Saint Petersburg, FLRegistration pendingN88PZ88pz LLC · Clifton Park, NYN88RARusso Mark · Stevensville, MTN88RHKeystone Flyer LLC · Avon, INN88TGMakushin Logistics LLC · Fairbanks, AKN88TLAh Legacy LLC · Orlando, FLN88VBBjelland Richard A · Galt, CAN88ZMFlorida Aero Services Sales Division Inc · Brandon, FLN8900PCabrejos-Guillen Roberto · Wichita, KSN8901PRead Robert S · Peoria, AZN8902PFarris Greg T · Ann Arbor, MIN8903PBeyer Marvin A Jr · Taft, TXN8905NHigh Noon Leasing LLC · Anchorage, AKN8905PBulle Jason L · Phoenix, AZN8906PComanche Inc · Leoti, KSN8907NCrain Roan · Cookeville, TNN8908NH & H Aviation LLC · Provo, UTN8909NKrull Doug · Hendersonville, TNN890HMarc Inc · Bolton, MSN8910KCoulter Ts LLC · Midway, UTN8910NRam Aeronautics LLC · Wichita Falls, TXN8910PComanche LLC · Peachtree City, GAN8911PVarga Craig S · Chino Valley, AZN8914NTreetop Flyers LLC · Vashon, WAN8914WDines Stephen R · Monument, CON8915PLegacy Aviation Mid-Michigan LLC · Kalamazoo, MIN8916NBundy Richard · Little Egg Harbor, NJN8917PLogsdon James C · Hanford, CAN8918NStratton Erin B · Baton Rouge, LAN891AWColonial Aviation LLC · Morristown, NJN891CBKal-1 LLC · Wichita, KSN8921POwens Gregory E · Kendallville, INN8922NKew Malcolm M · Hercules, CAN8923NMiller Jarred J · Burton, OH
Back to AD 71-13-01 R1