AD 82-27-13 R2
Registered aircraft · 755
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:82-27-13-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-27-13-R2')
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:82-27-13-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-27-13-R2') 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.
N369KJGrace Aire Inc · Corpus Christi, TXN36PBMarin Pacific International LLC · Apple Valley, CAN371MCSale Reported · Palm City, FLSale reportedN371WAAkro Attitudes Inc · Lighthouse Point, FLN3744UCristiani Sandra Elizabeth · Miami, FLN3746PSale Reported · Fort Lauderdale, FLSale reported, pending cancellationN376DGClark Anthony · Augusta, KSN376NCLima Delta Company Trustee · New Castle, DEN378MMBento De Deus Amarildo · Margate, FLN37PJDodson International Parts Inc · Rantoul, KSN385RMG Force Air LLC · Columbus, OHN38KCChanney Aviation Group LLC · Las Vegas, NVN38MCGulf Air Aviation · Wilmington, DEN38TWHones William G · Normandy Park, WAN390JDSevern Aeronautics Ltd · Annapolis, MDN396JHGoode Todd · Nampa, IDN398SPHillcrest Aviation LLC · Clear Lake, IAN39CACannondale Aviation L L C · Wilton, CTN39EHAir Travel Management Of Delaware LLC · Wilmington, DEN39HASmc Ltd · Somerset, WIN39TLDunamis Resources LLC · Lewes, DEN3VMAztec Worldwide Airlines Inc · Wilmington, DEN400CMAerial Surveys International LLC · Watkins, CON400HMBarneys Services Inc · Newton, IAN400RAJacko Josh E · Anchorage, AKN4023Maighnath Melissa · Jamaica, NYN403MCorporate Aircraft Group LLC · Annapolis, MDN403RGGkids Holdings LLC · New York, NYN4042MLinville Air LLC · Denver, NCN4043MPremier Air Charters Inc · Coram, NYN404ABcj LLC · Haines City, FLN406DZSpeedstar Aviation LLC · Kalispell, MTN406RSAero South Florida Inc · Deerfield Beach, FLN4072LN4072l LLC · Conroe, TXN4073LColumbia Asset Trust Corp Trustee · Wichita, KSN4074FMy Flyers LLC · Valley Stream, NYN4076TMike Jones Aircraft Sales Inc · Murfreesboro, TNN4077WMontgomery Charles · Tupelo, MSN4078BDodson International Parts Inc · Rantoul, KSN4078JStar Marianas Air Inc · Tinian, MPN40796Grant Aviation Inc · Anchorage, AKN4079HWarbelow'S Air Ventures Inc · Fairbanks, AKN40813Hendrix Charles W · Boca Raton, FLN4082TWarbelows Air Ventures Inc · Fairbanks, AKN4083W13 Aviation LLC · Leesburg, GAN4086EJj Aviation LLC · Allentown, PAN40872Ole South Aviators LLC · Athens, GAN4087CSherry-Aire LLC · Sidney, MTN4087KAggie Air Inc · Clifton, TXN4090UIsland Bound LLC · Dunedin, FL
Back to AD 82-27-13 R2