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.
N315SGBuell Travis W · Harper, TXFirst renewal noticeN31792Airscape Photo LLC · Issaquah, WAN318MFBusy Bee Helicopters LLC · Lone Jack, MON31GMJewell Scott M · Willow, AKN31UPGuardian Aero LLC · Flora, ILN321SKSouthern Aircraft Consultancy Inc Trustee · Casper, WYN324CSBrush Country Helicopters LLC · Laredo, TXN3264UTri-B Air LLC · Plano, ILFirst renewal noticeN328SSUnited Helicopter Leasing LLC · Honolulu, HIN32GSZeigler Corey M · Harrisville, NYN331ESJackson Paul D · Chesapeake, VAFirst renewal noticeN333LESky Photoshop LLC · Winter Garden, FLN334WCFarmland Developers LLC · Jonesboro, ARN335TBpu Enterprises LLC · Schuylkill Haven, PAN336SGAndrade South Florida Services Inc · Plantation, FLN337MGTew-Mac LLC · Tewksbury, MAN338SGMaine Rock And Recycling LLC · Rollinsford, NHN344BBMansfield Heliflight · Milton, VTN344ESLake Superior Helicopters LLC · Duluth, MNN344LCDuyk Charles W · Saint Petersburg, FLN344RLRed R44 LLC · Wilmington, DEN344SAShier Aviation DBA · San Diego, CAN344YUniversity Of North Dakota · Grand Forks, NDN34TBAmerican Helicopter Co LLC · Maiden, NCN350DMR&J Helicopters LLC · Port Byron, ILN363SKKamasano LLC · Highland, CAN368TMStriker LLC · Lewes, DEN369ELErickson Logging Inc · Gig Harbor, WAFirst renewal noticeN379CCSmith Jason · Calliham, TXN391LVSmart James T · Spurger, TXN393NMAce High Helos LLC · El Campo, TXN40014Ar Racing Inc · Catawba, NCN4004MAirman Helicopter Inc · Fort Lauderdale, FLN4010YRegistered aircraftN4011ASky Helicopters Inc · Desoto, TXN4015GRobinson Helicopter Co · Torrance, CAN40363Raider LLC · Joplin, MON403WAAviatech Inc · Tamarac, FLN4040Parker Helicopter LLC · Watsonville, CAN4042QCharter Air Transportation LLC · Wayne, PAN40489Classic Drywall LLC · Richmond, KYN4053TSky High Helicopters LLC · Camarillo, CAN4054GWorks Mark S · Cincinnati, OHN4055KHarris William R Jr · Salisbury, CTN4055NKansara Sanjay · Coopersburg, PAN4055QAeroglyphs Raven One LLC · Portland, ORN4056VHillsboro Aero Academy LLC · Hillsboro, ORN406HLHelicopter Logging LLC · Lagrange, OHN411TCBusy Bee Helicopter LLC · Paulding, OHN411VFMay Ricky · Salem, VA
Back to AD 2000-07-03