AD 2000-16-05
Registered aircraft · 428
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:2000-16-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-16-05')
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:2000-16-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-16-05') 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.
N184PHEbhs LLC · Monroe, MIN18910US Aviation Training Solutions Inc · Titusville, FLN1893ALone Star Helicopter Inc · Lago Vista, TXN1902WUS Aviation Training Solutions · Titusville, FLN198DWWelch Troy O · Graford, TXN1995FMark Mackenzie LLC · Jordan Valley, ORN2024EJoslyn Larry J · Las Vegas, NVN2026YGulf Coast Helicopters Inc · Pearland, TXN2027TCannon Travis H II · Corinth, TXN2028JHeli-Tech Inc · Panama City, FLN202CCJoslyn Larry J · Las Vegas, NVN202SLConstantine Frank L · Flemington, NJN2034ZSchweizer Rsg LLC · Fort Worth, TXN2036MR&B Helicopters Inc · Calhoun, GAN2043CLouisiana Community And Technical College System · New Iberia, LAN20449J2 Aero LLC · Ringgold, GAN2044DMyalik Gennady K · Campobello, SCN2046CTexflight LLC · Beaumont, TXN204SLBethesda Family Lp · Auburn, CAN2051JMonke Farm & Cattle · Nickerson, NEN20536Joslyn Larry J · Las Vegas, NVN205SLSeaman Timothy James · Olyphant, PAN2062HRoonie Inc · Wilmington, DEN2062NRegistered aircraftN2065POakland Helidrone Industrial LLC · Auburn Hills, MIN20691High Life Helicopters LLC · Kalispell, MTN2074CJprg Aviation Inc · Orlando, FLN20826Lc Aviation LLC · Mocksville, NCN2086FN3793b Inc · De Smet, SDN2087QSchweizer Rsg LLC · Fort Worth, TXN2091ERebayr Inc · Mooresville, INN2093SSkyline Aviation Inc · San Angelo, TXN20974Hale Air LLC · De Soto, MON209MSLand & Air Surveying Inc · Malibu, CAN21003US Aviation Training Solutions · Titusville, FLN21133US Aviation Training Solutions Inc · Titusville, FLN211AZBerry Darrel L · Camden, TNN212MSSuper Shine Inc · State Center, IAN21379US Aviation Training Solutions Inc · Titusville, FLN21385US Aviation Training Solutions · Titusville, FLN2140HLindeman Jeff · Archer City, TXN21496Danos Oilfield Service LLC · Hobbs, NMN214TST Air LLC · Columbia Falls, MTN2157PKiller Lion Hunts LLC · Catalina, AZN2158THi Tech Helicopters Inc · Pocono Lake, PAN215MSMulcaire Jess E · Camp Verde, AZN21763Andrews Scott · Winnsboro, TXN2183SEmu Inc · Redwood City, CAN2196SHernandez Christopher A · Phoenix, AZN223TATomlinson Aviation Inc · Ormond Beach, FL
Back to AD 2000-16-05