AD 2000-25-08
Registered aircraft · 306
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-25-08')
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-25-08')
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-25-08') 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-25-08') 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.
N406AMAris Aviation Group LLC · Boulder City, NVN4074EAviation Trust Company LLC Trustee · Oklahoma City, OKN4075SD&B Global Ventures LLC · Key West, FLN410CKCharm City Aviation LLC · Baltimore, MDN420JABristow LLC · Lake Charles, LAN448AEShedhorn Construction Inc · Bozeman, MTN451HIsland Helicopters Kauai Inc · Lihue, HIN461SAAir Twinlite Inc Trustee · Wilmington, DEN474RSLabell Aviation LLC · Spring Hill, FLN48BGazelle LLC · Missoula, MTN4AKAris Aviation Group LLC · Boulder City, NVFirst renewal noticeN503PHCity Of Miami Police Department · Miami, FLN511SCSabercat Productions LLC · Scottsdale, AZN5202YU S Dept Of Homeland Security · Washington, DCN5204GU S Dept Of Homeland Security · Washington, DCN5204PU S Dept Of Homeland Security · Washington, DCN52ZXRichard Schuman LLC · Kailua, HIN531BJg Boswell Co · Corcoran, CAN540DBMaster Link Corp · Barceloneta, PRN543MMHappyheight Inc · El Monte, CAN547AMTrevor Corp DBA · Grayslake, ILN547SAShier Aviation Corp DBA · San Diego, CAN557CBChaparral Air Group · Grapevine, TXN568AMEurotec Vertical Flight Solutions LLC · Eudora, KSN573AMIsland Air LLC · Westbury, NYN576AMAris Aviation Group LLC · Henderson, NVN57954Ns Air Leasing LLC · Wilmington, DEN5805TStefenelli Aviation N-Tr Inc Trustee · AtterseeN5854ZPuerto Rico Electric Power Authority · Carolina, PRN5855ZPuerto Rico Electric Power Authority · San Juan, PRN596MSNs Air Leasing LLC · Wilmington, DEN596WAFleet Unlimited Inc · Pasadena, CAN600HDU S Helicopters Inc · Marshville, NCN603CMSoutheast Helicopters LLC · Miami, FLN6080RTemsco Helicopters Inc · Ketchikan, AKN608TTemsco Helicopters Inc · Ketchikan, AKN6094ETemsco Helicopters Inc · Ketchikan, AKN6094UTemsco Helicopters Inc · Ketchikan, AKN609TXCopters In Agriculture Llp · Sonora, TXN60TXTexas Department Of Public Safety · Austin, TXN611TCAircraft Trustee Services Inc Trustee · Dover, DEN613CMEurotec Vertical Flight Solutions LLC · Eudora, KSN614SDEurotec Vertical Flight Solutions LLC · Eudora, KSN617TVUS Helicopters Inc · Marshville, NCN619LHYukon Helicopters Inc · Bethel, AKN61CVState Of Montana Dept Of Fish Wildlife & Parks · Helena, MTFirst renewal noticeN61HLTiny Bubbles Aviation Inc · Pacoima, CAN61RKDylans Rv Center LLC · Sewell, NJN624ADEurotec Vertical Flight Solutions LLC · Eudora, KSN624KSAerial Coalition Surveillance LLC · Winnie, TX
Back to AD 2000-25-08