AD 2000-07-03
Registered aircraft · 557
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-07-03')
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-07-03')
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-07-03') 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-07-03') 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.
N240RMPollux Aviation Ltd · Wasilla, AKN241MGNewberg Sky Spray LLC · Hector, MNN241VSDjd Aero Corp · Wilmington, DEN244BHHelicopter Holdings LLC · East Falmouth, MAN244CCThompson Helicopters LLC · Uvalde, TXN244GHJakes Air Services LLC · Holt, FLN244JBSpier Ronald B · Springfield, OHN244KSSnodgrass Charles Kenneth · Boise, IDN244MKRegistered aircraftN244RHRobinson Helicopter Co · Torrance, CAN244RLSouthern Maine Helicopter LLC · Sanford, MEN244WBUpdraft LLC · Fort Wayne, INN246LCTop Gun Precision Ag LLC · Skidmore, TXN248DBAce Helicopters LLC · Colfax, WIN249DLGibsons Gas Inc · Holland, NYN24RTHillsboro Aero Academy LLC · Hillsboro, ORN250THUniversity Of North Dakota · Grand Forks, NDN2522PPfisters Helicopters Inc · Pasco, WAN255LCTrayer Jared T · Rollinsford, NHN258DLExtapa LLC · Wilmington, DEN264RHNomad Aircraft Leasing And Sales LLC · Panama City Beach, FLN26EHEvans Robert · Phillips, NEN272MGAircraft Evolution LLC · Miami, FLN275LESky Photoshop LLC · Winter Garden, FLN277KTMaxair Helicopters LLC · Kissimmee, FLN277LCN277lc LLC · Fairbanks, AKN2812DCompass Aviation Inc · Shelby, NCN286LHSolace Aviation LLC · Atglen, PAN287LHJft Re Development LLC · Bentonville, ARN288LExecutive Helicopters Inc · Myrtle Beach, SCN28TMSouthern Aircraft Consultancy Inc Trustee · Casper, WYN299HEHeli 44 LLC · Freeland, MDN29KYBlack Ops Aviation LLC · Moorhead, IAN29VMDragonfly Aviation LLC · Laredo, TXN29WNSpitzer Helicopter LLC · Woodland Hills, CAN300MKAgricultural Tours LLC · Kahuku, HIN3014B-Line Air LLC · Malcom, IAN3017PDragonfly Aviation LLC · Mirando City, TXN3039FSilverhawk Aviation Academy LLC · Caldwell, IDN3040PCedar Ridge Aviation LLC · Knox City, TXN304HGGeorgia Aviation Authority · Eastman, GAN3055SWcm Ventures LLC · Hondo, TXN305JSMiller Kale M · Mountain Home, TXN306MBSpitzer Helicopter LLC · Woodland Hills, CAN306VAVeracity Aviation LLC · Seguin, TXN307SHParker Helicopters Inc · Watsonville, CAN308EHLos Angeles Helicopters Inc · Los Angeles, CARegistration ineffective or invalidN310PBPuckett Dale · Ararat, VAN31261Lee Stan · Sarasota, FLN3156GBlack Ops Aviation LLC · Moorhead, IA
Back to AD 2000-07-03