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.
N4465VGreen & Schweers Inc · Batesville, TXN446SGCedar Ridge Aviation LLC · Knox City, TXN447BAHc01 LLC · Vero Beach, FLN447CFBleecker Lee M · Dousman, WIN447RCEmerald City Aircraft Leasing Inc · Port Orchard, WAN447SEmerald City Aircraft Leasing Inc · Port Orchard, WAN448BASpitzer Helicopter LLC · Woodland Hills, CAN449BASpitzer Helicopter LLC · Woodland Hills, CAN449BCMcbride Richard A · Deer Park, WAFirst renewal noticeN44EKBas Part Sales LLC · Greeley, CON44FEAirborne LLC · Wilmington, DEN44HDAir Assault Agricultural Aviation LLC · New Castle, VAN44HGHigher Ground Helicopters Of Cincinnati LLC · Miamisburg, OHN44HNCedar Ridge Aviation LLC · Knox City, TXN44NHJanitz Thomas B · Indianapolis, INN44NQSky West Aviation Inc Trustee · Albuquerque, NMN44TGBlue Water Flying Services LLC · Lumberton, TXN44XBBrennon Aviation LLC · North Fort Myers, FLN451ATMaxflight Helicopter Services Inc · Kissimmee, FLN4538GAarow Aircraft Leasing LLC · Mcminnville, ORN454WTAce Flight LLC · Houma, LAN45CABas Part Sales LLC · Greeley, CON45PGRaven Aircraft LLC · Camas, WAN463DSSalisbury David W · Gettysburg, PAN463SKP5 Aviation LLC · Ephrata, WAN467HABuell Travis · Harper, TXN469CBCentral Boiler Promotions Inc · Greenbush, MNN46TFHowell George Ryan · Conway, NCN4735HBrew F Robert · Valatie, NYN474LESky Photoshop LLC · Winter Garden, FLN478ATAirmen Testing And Training Inc · Lantana, FLN484ATHelicrop LLC · Menlo, IAN48CDSky Helicopters Inc · Desoto, TXN4911XLake Superior Helicopters LLC · Duluth, MNN493RDEmdo LLC · Missoula, MTN499LCLimocopter LLC · Orlando, FLN49CNVenture Air LLC · Leonard, NDN5011WSky Helicopters Inc · Desoto, TXN506CDAloha Helicopter Tours LLC · Lihue, HIN509AZPfisters Farm Aviation LLC · Pasco, WAN509KMCedar Ridge Aviation LLC · Knox City, TXN50BABranning Aviation LLC · Orofino, IDN50KFBlade Capital Inc · Fort Lauderdale, FLN50KRVortex Air LLC · Philpot, KYN510LCLimocopter LLC · Orlando, FLN511LCLimocopter LLC · Orlando, FLN512LEHelipl LLC · Winter Garden, FLN514CHWehrli Mark A · Missouri Valley, IAN516JPFranjojo Airways LLC · Farmingdale, NYN516MJSeaton Flying Services Inc · Kileen, TX
Back to AD 2000-07-03