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.
N41279Paratus Air DBA · Auburn, INN413DBEstelle Karsen · Mc Neal, AZN41402Isofly LLC · Canyon Country, CAN4154CSky Helicopters Inc · Garland, TXN41584D Luckie LLC · Kalispell, MTN4162MSilverhawk Aviation Academy LLC · Caldwell, IDN416HHRotorwing LLC · Sheffield, ILN4175PAero Specialty Finance LLC · Chesterfield, MON4181XFly For Fun Aircraft LLC · Rockville, MDN41842Robinson Helicopter Co · Torrance, CAN418AFSkye Co LLC · South Williamson, KYN41BEVintage Aero Collection Inc · Wilmington, DEN41LYFedflyt LLC · Russell Springs, KYN4204WWilbourne Danny L · Melbourne, FLN4214MLawler Helicopter Leasing LLC · Rochester, MIN422FIntegrity Aircraft Title Holdings LLC · Portland, ORN422RXEmerald City Aircraft Leasing Inc · Port Orchard, WAN422WHAirman Helicopter Inc · Fort Lauderdale, FLN4230HHonolulu Helicopter Tours Inc · Honolulu, HIN4269UAero380 Corp · Wilmington, DEN427AFExecutive Jet A LLC · Danbury, CTN427RAHilty Benjamin D · South Boston, VAN430AFAir First LLC · Kalispell, MTN430DERotorwing LLC · Sheffield, ILN433SKRycoe Air LLC · Auburn, NYN436MRCedar Ridge Aviation LLC · Knox City, TXN437LMGigliotti Darin · Pueblo, CON438DEAirduce LLC · Cheriton, VAN43ALFloyd Air LLC · Searcy, ARN440TKTim Kepp LLC · Point Pleasant, PAN441EKSkf Holdings LLC · Breckenridge, TXN441HQSpitzer Helicopter LLC · Woodland Hills, CAN441KTHawaiian High LLC · Kaneohe, HIN441MRHillsboro Aero Academy LLC · Hillsboro, ORN441PFBusy Bee Helicopters LLC · Dover, DEN441RHHobbs Jonnie L · Darnestown, MDN441TBMansfield Heliflight Inc · Milton, VTN4427HTotal Flight Aircraft Leasing LLC · Apex, NCN442BHAfg Marietta LLC · Woodstock, GAN442EKCrop Doctor Aviation Inc · Hill City, KSN442MDMagill Zane · Castell, TXN442MGYeti Heli LLC · Westminster, MAN442MRSleigh Helicopter LLC · Palm City, FLN442RTRm Capital Holdings LLC · Hockessin, DEN442UKSpitzer Helicopter LLC · Woodland Hills, CAN443DCSouthern Aircraft Consultancy Inc Trustee · Casper, WYN443LCBlack Beauty Helicopters LLC · Davie, FLN444DVSky High Helicopters LLC · Camarillo, CAN444RHHelisafe Inc · Long Beach, CAN444VHMf Helicopters LLC · East Troy, WI
Back to AD 2000-07-03