AD 2000-08-22
Registered aircraft · 433
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-08-22')
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-08-22')
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-08-22') 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-08-22') 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.
N600ESIron Horse Aviation LLC · Newton, IAN600FHFatv LLC · Henderson, NVN600FTLancair Of Texas DBA · Fort Worth, TXN600MWSale Reported · West SussexSale reportedN600NRSharcott Inc Trustee · Wilmington, DEN609RPRonald A Peterson Inc DBA · Orlando, FLN60BKBrim Equipment Leasing LLC · Ashland, ORFirst renewal noticeN622PBPope James · Lewiston, IDN62UCCbft LLC · Mobile, ALN630AGLafayette Aircraft Leasing LLC · Fort Lauderdale, FLN633JHJack Harter Helicopters Inc · Lihue, HIN641LBGr (Uk) Inc Trustee · Wilmington, DEN64RSRainbow Air Inc · Niagara Falls, NYN651RPPeasant Air LLC · Parkersburg, WVN65CRWinco Inc · Aurora, ORN66SDEnforcement Aviation Services Inc · Midway City, CAN672TSS2md LLC · Lillian, ALN678SKLga 1992 LLC · Aubrey, TXN67HFPadgett Ag Rotors LLC · Missoula, MTN690PDBoard Of Police Commissioners · Kansas City, MON690WAWindward Aviation Inc · Puunene, HIN691PDBoard Of Police Commissioners · Kansas City, MON692PDBoard Of Police Commissioners · Kansas City, MON69DVTripwire South LLC · Gettysburg, PAN69GECbft LLC · Mobile, ALN69NWNorthwest Helicopters LLC · Olympia, WAN69PFSanders Associates LLC · Bluefield, VAN69TPAirtime Marketing LLC · Middletown, DEN69VSWind River Aviation LLC · Lawton, OKN700CBChesapeake Bay Helicopters Inc · Chesapeake, VAN701KPKp Properties LLC · Auburn, WAN702SH702sh LLC · Kalispell, MTN70512Bank Of Utah Trustee · Salt Lake City, UTN705KPOceans Alaska LLC · Dover, DEN705MPSmith Mark K DBA · Hubertus, WIN7079KDah Aircraft LLC · Georgetown, SCN70JRAircraft Securities LLC · Wilmington, DEN711KVAa Leasing Lp · Kilauea, HIN715KVAa Leasing Lp · Kilauea, HIN7168FHelicopter Minit Men Inc · Columbus, OHN716CBCbhelos LLC · Chesapeake, VAN716KVAa Leasing Lp · Lihue, HIN719KVAa Leasing Lp · Kilauea, HIN721RPRatcliff Dustin · Saltville, VAN724HKHawkeye Helicopter LLC · Lyndon, KSN725MAviation Advantage Inc · Tabor City, NCN734HHHlh Leasing LLC · Wilmington, DEN734SLLaroche Aviation Services LLC · Bellaire, OHN735CBChesapeake Bay Helicopters Inc · Chesapeake, VAN743MHDah Aircraft LLC · Georgetown, SC
Back to AD 2000-08-22